Home Dashboard Directory Help
Search

RESTORE DATABASE <database_name> FROM DATABASE_SNAPSHOT missing WITH STATS by Miron contrib


Status: 

Resolved
 as By Design Help for as By Design


1
0
Sign in
to vote
Type: Bug
ID: 735132
Opened: 4/2/2012 5:07:11 PM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

I think this is a bug, missing feature.
Although it could be a good suggestion.
Please help classify this issue correctly.

Issue:
when attempted to run command "RESTORE DATABASE <my_database_name> FROM DATABASE_SNAPSHOT = '<my_database_snapshot_name>' WITH STATS = 5

got back error message. Message reads:

Msg 4355, Level 16, State 2, Line 1
The revert command is incorrectly specified. The RESTORE statement must be of the form: RESTORE DATABASE <x> FROM DATABASE_SNAPSHOT = <y>.


---

Interestingly, parsing this statement ( under SQL Server Management Studio "Query" top level menu click on "Parse" ) completes with message, message reads: "Command(s) completed successfully."

Product: SQL Server 2008
Product version: 10.0.2531

SQL Server management Studio output of "Copy Info" under "Help->About" top level menu:

Microsoft SQL Server Management Studio                        10.0.2531.0
Microsoft Analysis Services Client Tools                        10.0.1600.22
Microsoft Data Access Components (MDAC)                        6.1.7600.16385
Microsoft MSXML                        3.0 6.0
Microsoft Internet Explorer                        8.0.7600.16385
Microsoft .NET Framework                        2.0.50727.4959
Operating System                        6.1.7600
Details
Sign in to post a comment.
Posted by Miron contrib on 2/27/2013 at 12:41 AM
Appreciate your informative reply.

It would be very nice if MSDN and SQL Server On - Line documentation reflected same.

Thanks,

Miron.
Posted by Microsoft on 2/19/2013 at 3:35 PM
REstoring a database from database snapshot is a completely different process and the standard restore statistics don't apply.
Sign in to post a workaround.