I think I store about 2 weeks for my production databases. If you only have 1 day, and find your last full backup had a problem, then you're stuck because...

ashwin4all1 (7/30/2009)

---

Hi

Shashi,

as per Brew said na this is lesson for the feture.We have to create good backup stategy on each user and system database,especially the database more than 500 MB...

ps (7/29/2009)

---

Refer this BOL link to know about fill factor.

http://msdn.microsoft.com/en-us/library/ms177459.aspx

A fill factor of 30 means 30% of space within...

Right click database -> tasks -> Generate scripts -> "Choose Script Options" Set "Script Indexes " to TRUE

Edit: maybe you meant as a scheduled job ? Then ignore above.

sashikanta.mishra (7/28/2009)

---

Hi Gill,

No i have not taken the Backup of the database before i drop the table. But any way i have taken the data of that table in a...

You need the "Generate Change Script" icon. Your toolbar settings are different from mine, but once you find it, click it before you finalize your table changes. It will build...

Kevin Mao (7/22/2009)

---

Could you check how many free space in the Data_3.ndf

Did you do any reindex before shrinkdatabase which will increase the file size?

Maybe you can try this statement...

Thanks !

Keep in mind that you cannot restore from 2005 back to 2000. I know it wasn't part of your question but might be relevant to whatever else you are doing.

1) Restore with STOPAT = 10:29, then manually re-enter the correct transactions after that point

or

2) Restore database to a new name TEST_1029 at 10:29. Then restore the full database...

I also like Idera's Diagnostic Manager. Wish I had it at my new job.

I think the newer version of WhatsUpGold has quite a bit of server monitoring capability, but...

".. I think you should set your recovery model of the database into "simple" recovery instead of "full" mode..." No thanks, it's a production database.

"... You say the...

Jack Corbett (7/15/2009)

---

You design reports using Business Intelligence Design Studio (BIDS) which is included in the SQL Server 2005/8 client tools install, or if you already have VS 2005 installed...

No, I'm not the owner. It's a Windows account that's used across servers in many places without issue except in this one case.

We used to own Lumigent Log Explorer. It can be used to recover lost data from log files. It might be more trouble than the earlier suggestion of doing a...