bhavesh_183 (9/7/2009)

---

Hi

I have got the SQL server 2005 enterprise, but it have 2 CDs, so what are the differences between CD1 and CD2? and so which one should i install...

mandarj123 (9/6/2009)

---

My Concepts are not really clear about following two things

if someone can give description with sum good example or

sum good links to refer to i wud be thankful

first topic...

This is the link that Gail provided to you before:

See - http://sqlinthewild.co.za/index.php/2008/10/20/what-is-fragmentation/

you can use the frequency of the job to gauge how many entrys you will get and adjust the size based on that

MrT-SQL (9/7/2009)

---

Hi,

This looks like it could be a permissions problem. Possibly.

When you say 'optimization job' what exactly do you mean, do you mean a step in a maintenance plan...

Yes you can use it now, in production. I looked after several mirror groups when I worked at major airports.

If you are creating a new database, from the backup that you mentioned in your first post. on the same server as the original database. you will need to do...

dba-vb (9/7/2009)

---

hi,

i've a database with full text enabled, by backing up this database,need to restore this backup to new database.

RESTORE DATABASE NEWDB

FROM DISK ='\\DBSERVER\OLDB.BKP'

WITH REPLACE

But it...

Duplicate topic.

post all replies to

http://www.sqlservercentral.com/Forums/Topic783689-146-1.aspx.

try not to post multiple time, edit your existing topic if you need to add to it

Gary Cobden (9/7/2009)

---

I have a Rebuild Index Maintenance Plan to rebuild indexes on all databases which fails with the following error:-

Failed:(-1073548784) Executing the query "ALTER INDEX [P08_AA_AcctPeriod_PK] ON [dbo].[P08_TAA_AcctPeriod] REBUILD...

anshu84onnet (9/7/2009)

---

Hi i have heard that we cant restore copy only back up.because it does not make change in LSN.but we are using this command and restore is going successfully...

duplicate topic

all replies to this topic

http://www.sqlservercentral.com/Forums/Topic783646-146-1.aspx

your welcome 😀

The only thing that I can add to this, is that each company is different and the resources and access that you have are different.

Powershell has to be installed and...

depends on...