Thanks for the help. I was able to script the create index event. Now, Do i need to add a line to drop each index if it exist?

Looks like that does the trick. I appreciate the help especially during a day off.

Frank thanks for the quick reply. I have a couple of questions

1) please explain the first insert into #showme

"select 123, '10001,10002,10003,10004,10005,10006,10007'"

I need to parse over 600 records...

I understand i can use views to make reporting easier. The problem i have is that in the sysprotects table the columns field is varbinary. I am having...

our primary database backup file is approximately 17-20 gb. We dump to a seperate raid array over a gb switch. Our backup times are not unreasonable. We...

Actually all of our backups are to disk.  We found arcserve's sql agent to be unreliable, so we began dumping to disc then using arcserve's file agent to backup our...

I changed our Raid Configuration on our test server from Raid 5 to Raid 1 + 0. The change in raid type reduced our restore time from 1 hour...

Is there any way to prevent the preparation time for the Restore. IE: eliminate the format or enable quick format?

Cool.  Thanks for the help.

I am looking for a good resource to help me optimize my hardware configuration.  I've been given a sizable budget to purchase new raid controllers and hard drives.  My box is...

quote:

---

3. Restore transaction log backup from last diff backup untill the transaction log backups have bridged 12PM FULL backup.

4. Restore latest diff...

My goal is to reduce potential data loss to 1 hour. I originally planned to run 2 FULL backups a day followed by Differentials every hour. With this...