help with Creating a Snapshot Please

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

help with Creating a Snapshot Please

Author

Topic

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2008-01-23 : 07:54:13

hello everyone

i am going through the self kit book to get my MCTS and i am stuck on
one of the practices. Creating a snapshot

I typed in

create database snapshottest
on
(
Name= 'Adventureworks_data',
Filename = 'C:\program files\Microsoft SQL server\mssql.1\mssql\data\snapshottest.ds')

as snapshot of adventureworks
i get the error message

msg 5127 level 16 state 1 line 1
all files must be specified for database snapshot creation
missing file "AdventureworksFT_data".

i have not stated AdventureworksFT_data

i stated Adventureworks_data

why is it asking for AdventureworksFT_data

can someone please tell me if the syntax is wrong or is there something missing

Regards

Rob

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2008-01-23 : 08:59:13

can anyone please help

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-01-23 : 09:03:44

Is it really urgent? If so, pay an consultant to help you. Or phone Microsoft.

Please remember that we help here for free, on our spare time because we want to. Not that we have to.
You will get an answer. If not soon you will get it later.

E 12°55'05.25"
N 56°04'39.16"

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2008-01-23 : 09:06:45

alright mate

sorry to be a pain in the arse.

i will be patient.

Regards

Rob

gedwards
Starting Member

19 Posts

Posted - 2008-01-23 : 09:54:23

Looks like you have .ds, when it should be .ss
See this article.
Greg E
http://msdn2.microsoft.com/en-us/library/ms175876.aspx

Greg E

jonnom
Starting Member

3 Posts

Posted - 2008-03-07 : 09:42:21

quote:
Originally posted by masterdineen

hello everyone

i am going through the self kit book to get my MCTS and i am stuck on
one of the practices. Creating a snapshot

I typed in

create database snapshottest
on
(
Name= 'Adventureworks_data',
Filename = 'C:\program files\Microsoft SQL server\mssql.1\mssql\data\snapshottest.ds')

as snapshot of adventureworks
i get the error message

msg 5127 level 16 state 1 line 1
all files must be specified for database snapshot creation
missing file "AdventureworksFT_data".

i have not stated AdventureworksFT_data

i stated Adventureworks_data

why is it asking for AdventureworksFT_data

can someone please tell me if the syntax is wrong or is there something missing

Regards

Rob

jonnom
Starting Member

3 Posts

Posted - 2008-03-07 : 09:45:00

you will need to specify all filegroups for the database which you are making a snapshot of Eg: (example B of the following link)

http://msdn2.microsoft.com/en-us/library/ms175876.aspx

lankadilla
Starting Member

1 Post

Posted - 2011-04-19 : 03:46:03

Ans:-
create database snapshottest
on
(
Name= 'Adventureworks_data',
Filename = 'C:\program files\Microsoft SQL server\mssql.1\mssql\data\snapshottest.ds'),
(
Name= 'AdventureworksFT_data',
Filename = 'C:\program files\Microsoft SQL server\mssql.1\mssql\data\snapshottest1.ndf')
as snapshot of adventureworks

now no need to worry with snapshot.

dilla.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources