- Configure Database for Single User
ALTER DATABASE mydatabase SET SINGLE_USER WITH ROLLBACK IMMEDIATE - Restore Database
- Configure for Multi User
ALTER DATABASE mydatabase SET MULTI_USER
SQL Server 2005: Database Recovery
I'm hoping this code will work when I try disaster recovery after tonight's failed deployment:
Subscribe to:
Post Comments (Atom)
1 comments:
There is a not bad tool which is able works with sql files,as is known tool is free-sql server recovery tool,program repair data from corrupted databases in the MS SQL Server format (files with the *.mdf extension),supports data extraction via the local area network,can save recovered data as SQL scripts, it is also possible to split data into files of any size,compatible with all supported versions of Microsoft Windows, such as Windows 98, Windows Me, Windows NT 4.0, Windows 2000, Windows XP, Windows XP SP2, Windows 2003 Server, Windows Vista,tool supports the following database formats: Microsoft SQL Server 7.0, 2000, 2005,also can repair .mdf files of Microsoft SQL Server 2005, repair mdf file of Microsoft SQL Server 2005 (64-bit).
Post a Comment