We just recently found out that our production database (SQL Server 2005) was running on an evaluation license and that it would expire very soon. So we went ahead and bought a license for SQL Server 2005 Enterprise Edition and installed it last night. Before we started, we did full backups of SQL Server so that we could just restore the DB. Then we uninstalled the evaluation version and installed the enterprise version. However, when we tried to restore the master database, we got an error stating that the build/version number of the master database restore and the target SQL Server instance were different and that the restore could not be done. We decided not to try too hard and just manually entered the data into the already existing master database.
Well, we did not discover until this morning that our encrypted data was not decrypting because the service master key was not matching the one that was used to encrypt our data. We realized that we do not have any backups for the service master key and we do not know the user credentials that were used to create the original service master key.
We tried http://support.microsoft.com/kb/264474 already, but we could not get past step 6. We got the build/version mismatch error.
My question is does anyone have any ideas or suggestions on how to either get the master database to be restored or to get the service master key extracted? Our business is basically at a hault until we get this data encrypted.
Iam planning to move the production server from one server to another. Can any one tell me how to do the migration of the master,model and msdb database. Help in this regard is highly appreciated.Is it ok if I do the dts for these three databases Thanks Naveen.
In SQL 7 Books Online, the suggested method for disaster recovery is to restore the master database along with msdb and user databases.
I am testing this and have an issue restoring the master database. I start SQL in single user mode connected as sa. Using Enterprise Manager to initiate the restore I get the following error:
Microsoft SQL-DMO (ODBC SQLState:01000) ConnectionTransact (GetOverlappedResult()) Connection broken.
This stops SQL Server, and prevents subsequent connections and the only fix is to rebuild the master database.
Any ideas?
Although user databases can be recreated and restored without restoring the original master, configuration, security and user logon information is lost without it.
Hi all, I'm hopeful that someone can help.. I'm working with my DRP scripts, and am having some trouble. First I run Rebuildm with no issue, sql works fine (btw we're on SQL7 SP2) then I start sql in single user mode sqlservr -m next, I attempt to restore my master db from a dump, and receive the following error: Getpage: bstat=0x9, sstat=0x1, cache pageno is/should be:objid is/should be: (1:988)/(1:988)6/30 ... IAM indicates that page is NOT allocated to this object Error: 605, Severity: 21, State: 1. Error: 3151, Severity: 21, State: 0 The master database failed to restore. Use the rebuildm utility to rebuild the master database. Shutting down SQL Server.. PLEASE HELP!
I am experiencing a lot of problems trying to restore the master database for a mock Disaster situation. I started SQL server in single mode using sqlservr.exe -m at the command prompt and then tried to restore the master database but was unsuccessful. Does anyone know the steps of how this can be accomplished. Thanks Kevin
Hi Guys, I am trying to restore a master database from a server to another server. I followed all the step necessary to restoring the Master database. I first rebuild the master and then put the master in single user mode and then trying to restore the master database. The problem is the database says master database is restored success fully and also it shut down the service. When I restart the server it startup and then after some minuite it doesnt show started status in the services panel. when I refresh the services it still doesn't say started. I also try to connect to the database and it says the server is not available. I have added service pack 3a to this new server. Don't know why it says that. Any have any idea. I have to do this immediatly and please guys, let me know any solution to this problem. I really appreciate your help. Thanks again. Cheers!
Hi All, I have a production issue should be attended immediatly. We are running SQL Server 2000 in a production environment. The master database is corupted. We have a backup of Master database. But the server service is not starting. I don't know how to restore the master database from the backup when server is not up. Can u please letme know how to do it ASAP. I really appreciated for your grate.... help. Thanks in advance. Jamy
I needed to take a backup of a database and use it on another server and followed the steps in the following article to do so:
[URL]
It restored fine on the destination but I still need to use the original and I get the following error from the application when trying to use it:
create a master key in the database or open the master key in the session before performing this operation.
This is after doing the following to try and restore the master key.
USE <database>; GO open master key decryption by password = '<password>' RESTORE MASTER KEY FROM FILE = 'C:exportedmasterkey' DECRYPTION BY PASSWORD = '<password>' ENCRYPTION BY PASSWORD = '<password>'; GO
After doing this I got the message:
The old and new master keys are identical. No data re-encryption is required.
I have to restore 'master' database in sql server 2005. The server has two instances. As part of restore strategy, I need to bring server in single user mode. When I ran following in command prompt sqlservr.exe - m -s via Binn Folder I got following error message.
Your SQL Server installation is either corrupt or has been tampered with (SQL Registery version not same as server). Please uninstall then re-run setup to correct this problem.
I have been clueless how to resolve this problem. Your help will be appreciated.
I can't find any articles telling me how to restore master,msdb databases on a sql 2000 cluster. Both in a active/active setup and active/passive set up. I am experimenting to see if normal restore in a stand alone environment would work. But I would like to know if there is a definitive method to use. Looked on BOL could not find anything.
One of the forum user suggests that I need to post the following issue to this area relating on data corruption.
Here's where I am up to in detail: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=74599
Summary: Basically, I made a daily automatic testing restore to TARGETSERVER and every database are ok except the master database. I do DBCC CHECKDB on master database in the SOURCESERVER .. and no error what so ever. But the result of restoring of the master backup does. This happens everday.
Now, I checked and verified that my backup version of SQL Server is the same as the version installed on the computer I'm restoring too.
I have SQL Server on a production machine that I backed up and want to test a full restore on a dev machine to make sure it will work when I need it to.
Now that I've run the restore command on my tape backup and go to restart the SQL server service I receive:
Configuration block version 0 is not a valid version number. SQL Server is exiting. Restore the master database or reinstall.
I'm afraid I don't understand why this is happening. If the builds are the same, then shouldn't restoring the MASTER database have worked normally and I'd be able to restart the service now?
HELP We are preparing Disaster recovery plans, and I need to recover the SQL servers. When testing this, I have run REBUILDM, and then set sql to single user and attempted restore of master. I receive error messages: "2001-11-16 15:36:24.33 spid6 Getpage: bstat=0x9, sstat=0x1, cache 2001-11-16 15:36:24.34 spid6 pageno is/should be: objid is/should be: 2001-11-16 15:36:24.34 spid6 (1:988)/(1:988) 6/30 2001-11-16 15:36:24.84 spid6 ... IAM indicates that page is NOT allocated to this object 2001-11-16 15:36:24.88 spid6 Error: 605, Severity: 21, State: 1. 2001-11-16 15:36:24.95 spid6 Error: 3151, Severity: 21, State: 0 2001-11-16 15:36:24.95 spid6 The master database failed to restore. Use the rebuildm utility to rebuild the master database. Shutting down SQL Server.."
Subsequent attempt cause the same, UNLESS i reapply SP2 (the version running when the Master was backed up)
Everytime I attempt to restore the master database, it corrupts the entire instance of SQL server 2000. I have been using the method out on Microsoft's Knowledgebase:
http://support.microsoft.com/kb/822852/en-us
using sqlservr.exe and the switches -c -m -T3608 -T4022
I would like to know if anyone has other methods of restoring the master database from a backup device.
I am trying to restore my master database to a new server in sql 2000. I have started sql in single user mode from the command line and connected to enterprise manager and attempted to do the restore. I also tried query analyzer and used the restore database from disk ='file path of backup' used the move option with the correct file path and on both counts received the same error message...
Any ideas? The connection is then broken (which I would expect anyway as restoring master shuts down sql but, I checked and it has not restored the db)
I am running through a Disaster Recovery scenerio and I am having trouble restoring the Master and msdb DBs to a recovery box.
My production is a default Instance on WIN2k Server - SQL Server is 2000 Standard, sp3a
The box I'm trying to recover to is a Named Instance on WIN2003 server - SQL Server 2000, sp3a
I stopped/restarted my recovery server with -m and -T3608 startup parameters but when I attempt to restore the master backup from my production box to the recovery box, I get an error - it's a blank dialog box with a big red X and it says: Microsoft SQL-DMO - ODBS SQL State - HY000
when I check the sql server log: it shows the Server started in single user then it says recovering master db then starting up master DB then it just hangs..
Server event viewer shows this: 18052:error 3151, severity 21, state 0
not much to go on.. does anyone know what I'm doing wrong???
I am trying to restore master to a new server but location of data and log files is different in this new server. The previous location was 'D:Program FilesMicrosoft SQL ServerMSSQLdata" the current location is in the C: Drive; when trying to restore using MOVE:
RESTORE DATABASE master FROM DISK ='\PfileserversqlbackupMDFfilesmaster_db_20070 8170121.BAK' WITH RECOVERY , MOVE 'master' TO 'C:Program FilesMicrosoft SQL Serverdatamaster.mdf', MOVE 'mastlog' TO 'C:Program FilesMicrosoft SQL ServerMSSQLdatamastlog.ldf'
I get the following error message:
The system database cannot be moved by RESTORE
Is there a way you can restore master to a different location?
We set up a test box and having been trying to move an entire instancefrom our production server to this one. I have moved all my createddbs using the RESTORE WITH MOVE. Now I am trying to move the Master,Model, and msdb. This is where I am having trouble. On the productionbox the dbs are stored on D:mssql$instancenamedata. On the testserver the data is stored in C:Program FilesMicrosoft SQLServermssql$instancenamedata. Also the server names are different.So I finally got the Master from production to restore over the test'scopy. Now the instance will not start. I was trying to use thefollowing code in cmd line to connect to the instace so I could thencopy model and msdb:sqlservr -c -f -T3608 -T4022 -sINSTANCENAMEWhen this is trying to connect I read it is failing and saying that theMDF and LDF may be corrupt or not there. The problem is it is nowtrying to look in D:mssql$instancenamedata instead of C:ProgramFilesMicrosoft SQL Servermssql$instancenamedata. Any ideas on how Ican change this, or if I have to reinstall the entire instace, not runinto this again?
I have a server attached to a SAN, all user db's are on the SAN, master, tempdb, and msdb are on the local machine. We will be replacing the machine (not the SAN) to a newer sql server. Our plan was to create the new server with same name, deattach current user db's,backup master and msdb, then connect new server with same name an IP to SAN. I then wanted to restore the master and msdb db's to the new machine, and attach the user db's. We are running log shipping to a stand-by server in this configuration. I was thinking I could let last tran log backup and copy occur, and then let the last restore happen on the standby. I would then shut down the agent. Should I not be able to restore the MSDB and master to the new server (as long as all file folder locations are the same) and be ready to go? Or are there issues when restoring the Master and MSDB to a new server from a different server.
Hi Everyone, I'm hoping someone can help me. We've had a SQL login deleted (special application one) and I understand the best way I can get it back, is to restore the Master database. Is this true ? All the manuals are working on the fact that Master has become corrupt & that it should be rebuilt before restoring. Ours is not corrupt, so am I ok to skip rebuilding it first ?
Can you restore the master database, running on windows server 2000, sqlserver 2000 from a backup that was taken from c: to another serverrestoring to d:?*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!
I'm trying to recreate a sql database on another server and I installed sql server 6.5 on a server and then restored the master db using the Sql Setup program. It worked without any errors, but it did not create the loginthat will use the database that I have not restored yet. Aren't the Logins storied in the master database?
Hi All, I took a backup of master,model and msdb database which was on D: drive and i tried restore it on C:. Now if i try to start sql server it comes out with a erorr that model database cannot be found and it keeps looking for model in D: drive which is not there.I tried restore of model with move option but it says cannot drop model as its system database.I tried attach detach but it does not understand tempdb as temp db is also on d: and i cannot understand how to move or point it to c:
I'm trying to rebuild from a meltdown. I'm using disk backup files. Icould have sworn that I had SQL Server 2000 SP3 installed on the oldmachine, but maybe not.With SP3 installed, I get a message along the lines that the restorecan't be done because the backup was created using server version134218262 and this server is version 134218488.I've searched the documentation and can't find any reference to thoseversion numbers.In any case, I thought SQL Server 2000 could restore backups createdon any SP level to any SP level.Any ideas?--Regards.Richard.
I noticed when I restore a master database to a server other then the one which created the backup of master, SQL Server contains the following three local security groups that were defined on the source server. The problem is these groups are "local" and do not apply to the server where master was restored.
If you then backup the master database on an instance named MARKETING_PROD and restore it to MARKETING_TEST, the security folder on MARKETING _TEST will now contain the following three entries.
These entries would be invalid because no such server exists and therefor no such local groups exists. There appears to be no Microsoft documentation explaining how to handle these groups when restoring master from one server to another. My assumption is that whenever restoring master to another server you must drop these three groups and add the correct corresponding groups along with the appropriate permissions. I don't understand why SQL Server would not rebuild this information for you during a restore.
moving to a new sql server box because of a problem with the SAN its connected to. started my named instance in single user mode and restored master. sqlserve.exe -c -m -s ovops now the instance won't start. tried starting it with the -t3608 switch.. won't start!! Its because my drive configuration is different on the new server than it was on the old server, I cannot start the instance because it is expecting model, msdb, temdb and all of the user databases on drives that don't exist?? what can I do?????
I'm having trouble with restoring the master db on w2k3 sql2000 sp3a to a Secondary Standby server. Firstly, I place the server in Single user mode and then restore the master db. The sql server then tries to restart sql services but immediately stops as soon as it starts up.
I did a full backup of a db from one server(Express2005) and trying to restore it to a different instance of SQL2005 on the same development machine. (Also had some fulltext columns if that means anything)
Many failures but finally got it to report all was successful except the icon in Object Explorer shows (Restoring...) with no indication of any real activity going on. It's a tiny database with hardly any data in it.
Just not sure what the heck is going on there. It also won't let me into the database until this the (Restoring...) goes away.
Does anyone know if there are any issues with restoring Master DB ontoa server running Standard Edition from a server running EnterpriseEdition of SQL Server?
