OK, I retract my reply.

Tara should consider the valid concerns listed.

sp_msforeachdb

Sounds like you have 2 different machines ?? You're not upgrading an existing machine from 2000...

Are you trying to rebuild the indexes through the GUI ? You will have better performance if you script out the code, then run it as a job. ...

You would probably be better served by starting a new thread rather than add to a 4 year old thread.

loki1049 (12/22/2010)

---

There is no exclamation mark. This is a view of a table not a query. I know in SQL Management studio 2008 the view into a table is actaully...

Would the default trace files be of use to at least get some information about what heppened between 12:00 and 4:00 ?

Learn about the different recovery models:

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

http://msdn.microsoft.com/en-us/library/aa173531(v=sql.80).aspx

I used this when looking for a phone number. I already knew which column to look in. If you don't know which column might have it, then I guess you...

Be thankful you only lost 4 hours, and put proper disaster procedures in place for next time.

I'm not familiar with that tool. I use SQL profiler to open the .trc file

premkuttan.lakshmanan (12/15/2010)

---

in sp_who2 the coressponding blkby for spid 101 is 101 and in the corresponding command column it shows as killed/Rollback . Does it mean that the activity is getting...

If this is a production database, then you should have frequent transaction log backups. If so, you can look to see when the T-log backups suddenly got big. That will...

Have you tried the restore operation with the corrected path, selecting "overwrite" ?

When you run this: select * from sys.traces

What is in "path" ?