December 3, 2012 at 7:44 am
I need to restored the master db file from one of my red gate backup files. I'd like to know the required steps to do this.
thank you.
December 3, 2012 at 8:30 am
First result of GOOGLE with your subject
1. Start the SQL Server in single-user mode.
· Open Control Panel->Administrative Tools->Services and stop the SQL Server instance.
· Open a command prompt and change directory to the SQL Server program folder
For instance, %programfiles%\Microsoft SQL Server\MSSQL.1\MSSQL\Binn
· Start SQL Server in single-user mode by running 'sqlservr.exe -m'
If this is a named instance, the -s argument must also be used, ie sqlservr.exe -m -sSQLEXPRESS
2. Restore the MASTER database using SQL Backup's command-line utility
· Open a second command prompt and change the directory to the installation directory of the SQL Backup Server components, ie %ProgramFiles%\Red Gate\SQL Backup\(LOCAL)
· If your current Windows logon has SYSADMIN access to the SQL Server, run this command:
SQLBackupc -SQL "RESTORE DATABASE [master] FROM DISK='<path to master backup>' WITH PASSWORD='<password>'" -I <instance> -E
· If it is necessary to use SQL security, run this command:
SQLBackupc -SQL "RESTORE DATABASE [master] FROM DISK='<path to master backup>' WITH PASSWORD='<password>'" -I <instance> -U <username> -P <password>
- If you are restoring the master database to a new (or rebuilt) server you will need to add the WITH REPLACE keyword
SQLBackupc -SQL "RESTORE DATABASE [master] FROM DISK='<path to master backup>' WITH PASSWORD='<password>', REPLACE" -I <instance> -E
3. Start the Microsoft SQL Server Service in normal (multi-user) mode
· Locate the first command prompt, which is running the SQL Server and displaying a log of operations
· Click in this window and press CTRL+C. The SQL Server should indicate it is stopping.
· Go back to Control Panel->Administrative Tools->Services and start the SQL Server Service, and any dependent services.
· In some cases, it may be necessary to restore other system databases (model and msdb), especially if the backup of master was taken from a previous version of SQL Server. The server does not need to be in single-user mode to restore these databases.
http://www.red-gate.com/supportcenter/content/knowledgebase/SQL_Backup/KB200804000249
December 3, 2012 at 8:36 am
HildaJ (12/3/2012)
I need to restored the master db file from one of my red gate backup files. I'd like to know the required steps to do this.thank you.
The easiest option I found when carrying out this exercise is to use the sqlbackup converter to convert from Redgate .SQB to native .BAK then restore the master backup via single user mode. Don't forget to use the REPLACE option in your restore command.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 3, 2012 at 8:42 am
The easiest option I found when carrying out this exercise is to use the sqlbackup converter to convert from Redgate .SQB to native .BAK then restore the master backup via single user mode. Don't forget to use the REPLACE option in your restore command.
Perry how can we achieve that? If did ,it is having high chance for corrupting the backup right.
December 3, 2012 at 8:47 am
If you do need to convert the database from the *.sqb format, we have a tool available for doing that.
If you are going to restore the master, we have some helpful posts to walk you through that process using our tools. It depends on which version of the tool you're currently using.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 3, 2012 at 11:45 am
Ratheesh.K.Nair (12/3/2012)
Perry how can we achieve that? If did ,it is having high chance for corrupting the backup right.
Not at all, I've never had an issue with the backup converter
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 3, 2012 at 12:12 pm
Great thank you very much. I'll try the command line to restore the master db.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply