Restore master db using a red gate backup file

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » Restore master db using a red gate backup...

Restore master db using a red gate backup file

Rate Topic

Display Mode

Topic Options

Author

Message

HildaJ

Posted Monday, December 03, 2012 7:44 AM

SSC Journeyman

Group: General Forum Members
Last Login: Today @ 12:11 PM
Points: 96, Visits: 268

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.

Post #1391951

Ratheesh.K.Nair

Posted Monday, December 03, 2012 8:30 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 8:57 AM
Points: 2,415, Visits: 3,375

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

Post #1391978

Perry Whittle

Posted Monday, December 03, 2012 8:36 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 5:53 AM
Points: 5,204, Visits: 11,158

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" Wink

Post #1391985

Ratheesh.K.Nair

Posted Monday, December 03, 2012 8:42 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 8:57 AM
Points: 2,415, Visits: 3,375

Perry how can we achieve that? If did ,it is having high chance for corrupting the backup right.

Post #1391990

Grant Fritchey

Posted Monday, December 03, 2012 8:47 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 2:20 PM
Points: 13,381, Visits: 25,171

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
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software

Post #1391997

Perry Whittle

Posted Monday, December 03, 2012 11:45 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 5:53 AM
Points: 5,204, Visits: 11,158

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" Wink

Post #1392100

HildaJ

Posted Monday, December 03, 2012 12:12 PM

SSC Journeyman

Group: General Forum Members
Last Login: Today @ 12:11 PM
Points: 96, Visits: 268

Great thank you very much. I'll try the command line to restore the master db.

Post #1392107

« Prev Topic | Next Topic »

Permissions