Restore failed for Server 'test'

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Restore failed for Server 'test'

Author

Topic

amirs
Constraint Violating Yak Guru

260 Posts

Posted - 2008-06-26 : 02:25:35

hi
i have restore exsisting database use backup file.so following error are dispaly

TITLE: Microsoft SQL Server Management Studio
------------------------------

Restore failed for Server 'test(Microsoft.SqlServer.Smo)

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

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

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

------------------------------

The file or filegroup "test" cannot be selected for this operation.
RESTORE DATABASE is terminating abnormally. (Microsoft SQL Server, Error: 3219)

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

------------------------------
BUTTONS:

OK
------------------------------

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-06-26 : 09:25:06

How did you restore? show us command.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources