Posts
26
Comments
38
Trackbacks
0
SQL Server Management Studio crashed - recover unsaved sql query
If for some reasons SQL server instance dies or it crashes and if you had an unsaved query - you could still recover it from the backup files that sql server creates whenever it crashes unexpectedly.

The path for the backup .sql files is something like the following  -

C:\Users\USER_PROFI\Documents\SQL Server Management Studio\Backup Files\Solution1
posted on Thursday, February 28, 2013 5:31 PM Print
Comments
Gravatar
# re: SQL Server Management Studio crashed - recover unsaved sql query
spinxwebdesign
3/2/2013 10:54 AM
Yeah. Thanks for the information. I have carried out this to backup my data when my hard drive was crashed.
Gravatar
# re: SQL Server Management Studio crashed - recover unsaved sql query
Joe Smo
4/19/2013 8:04 PM
NOT ALWAYS TRUE - SQL Server Management Studio\ may or MAY NOT contain a "Backup Files\" deirectory
Gravatar
# re: SQL Server Management Studio crashed - recover unsaved sql query
Dev
2/4/2014 12:04 PM
Thanks a ton..it worked for me

Post Comment

Title *
Name *
Email
Comment *