Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

This is not a good day for me. I have a backup (master.bak) for SQL Server 2005 Express SP4 (v.9.0.500) that I want to restore to my master db instance. I am running SQL Server in single-user mode (sqlservr.exe -m), connect to the instance, then I do a Task... Restore. This is the error I get:

TITLE: Microsoft SQL Server Management Studio Express

Restore failed for Server 'GINO\SQLEXPRESS'. (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476

------------------------------ ADDITIONAL INFORMATION:

Failed to retrieve data for this request. (Microsoft.SqlServer.Express.SmoEnum)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476


An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)


A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - The pipe has been ended.) (Microsoft SQL Server, Error: 109)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=109&LinkId=20476

Please help me restore my backup database so that I can continue along with my business!

share|improve this question

migrated from serverfault.com Dec 20 '11 at 19:40

This question came from our site for professional system and network administrators.

1 Answer 1

up vote 5 down vote accepted

Use SQLCMD instead of Management studio to do the restore and try this. (Since you are using a named instance make sure to use the -S switch for SQLCMD)

C:\> SQLCMD -S GINO\SQLEXPRESS
> RESTORE DATABASE master FROM DISK='C:\SQLBackups\master.bak' WITH REPLACE;
> GO

Obviously replacing the path to your backup with the real path of where your backup is.

Have a look here for (slightly) more information.

share|improve this answer
1  
I have tried your solution with an instance of SQLEXPRESS running in single-user mode: –  JFB Dec 19 '11 at 22:55
    
Got it! I had to restart the server with sqlcmd -m -S myserver –  JFB Dec 19 '11 at 22:59
    
Great! Yeah, I was just getting in to make sure you were starting the server properly :) That command doesn't start SQL Server, though. It's just a command-line client to issue commands to SQL Server. –  squillman Dec 19 '11 at 23:09

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.