Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ngoodearl
Starting Member
1 Post |
 Posted - 2008-03-25 : 06:52:52
|
| Hi all,I made a mistake today when clearing out some sql server db logs and deleted the mdf file. I have a backup of the db but its 60GB!! The backup file is stored on the same drive as the db.I am currently restoring a smaller db (1GB) and its taking ages when I did a restore from enterprise manager. Is there a way to speed this up? Any suggestions is much appreciated.Thanks,Nathan |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-25 : 09:30:09
|
| What do you mean by clearing logs and deleting MDF files? Don't touch it. How did you restore the DB? Did you choose recovery option while restoring and backup files is on local computer or network share? |
 |
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2008-03-25 : 15:30:48
|
| Was the SQL Server shutdown? I thought if the database was online, the .mdf file would be in use and otherwise un-delete-able??Terry |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-25 : 22:37:54
|
| Run 'sp_who2 active' in query analyzer. If you don't see restore process in the result, just run 'restore db_name with recovery' to get the db out of loading status. |
|
|
|
|
|
|
Tips for DB restore