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 |
|
Rheinhardt
Yak Posting Veteran
66 Posts |
 Posted - 2011-03-02 : 00:30:19
|
| Hi,My system shut down while I was busy with a script (which I haven't saved yet) because of a virus...is there anyway that Sql Server can auto recover my work?Or is it lost?If yes, were can i go look.Thanks |
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-03-02 : 06:50:08
|
| In case of unexpected shutdown of SSMS,the SSMS on the next start up would show a list of files that were lost.It will show a list of those files with two options whether you would want to recover them or not.If that does not happen then your best bet would be go and search *.sql files in your local Temp folder.PBUH |
 |
|
|
sql_server_dba
Posting Yak Master
167 Posts |
Posted - 2011-03-02 : 17:55:01
|
| you can find them in \My Documents\SQL Server Management Studio\Backup Files folder |
|
|
|
|
|
|
Auto recovery