My server crashed i had full back up my .BAK file for every database and i reinstalled a fresh verion of sql server 2000 enterprise and when i comme in enterprise manger to restor the master its telling me i need to be in single user mode what do i do.Change it to single user mode. use sp_dboption.|||sp_dboption pertains to user databases, not to MASTER.
BOL for SQLSERVR command line:
-m
Indicates to start an instance of SQL Server in single-user mode. Only a single user can connect when SQL Server is started in single-user mode. The CHECKPOINT mechanism, which guarantees that completed transactions are regularly written from the disk cache to the database device, is not started. (Typically, this option is used if you experience problems with system databases that require repair.)sql
Showing posts with label plz. Show all posts
Showing posts with label plz. Show all posts
Wednesday, March 21, 2012
recovering database plz help
Wednesday, March 7, 2012
Recove the database
hi all,
i was importing the data from a another database, when it was completed, old data was deleted..means new data over write upon old data...
Plz tell me any method to recover the old data.....
i am serious in trouble...
thanx
Sajjadno any reply yet ... :(|||If you have backup of your database before the import operation use the backup and restore wizard use the restore from device option, be sure to click on the wizard to get the .bak file location. The rest is easy because SQL Server lets you choose the name of the new database and takes you back to the last backup. Hope this helps.|||No i am not take any backup :(
so what i do... ?
plz help..|||There are two tools in this link which may help and may is the operative word. Hope this helps.
http://www.sql-server-performance.com/greg_robidoux_interview.asp
i was importing the data from a another database, when it was completed, old data was deleted..means new data over write upon old data...
Plz tell me any method to recover the old data.....
i am serious in trouble...
thanx
Sajjadno any reply yet ... :(|||If you have backup of your database before the import operation use the backup and restore wizard use the restore from device option, be sure to click on the wizard to get the .bak file location. The rest is easy because SQL Server lets you choose the name of the new database and takes you back to the last backup. Hope this helps.|||No i am not take any backup :(
so what i do... ?
plz help..|||There are two tools in this link which may help and may is the operative word. Hope this helps.
http://www.sql-server-performance.com/greg_robidoux_interview.asp
Subscribe to:
Posts (Atom)