why I can not create a snapshot for AdventureWorks2008

Question

Hi,

I just downloaded AdventureWorks2008_SR4.exe and installed all the samples in MSSQL 2008.

I already could see the related AdventureWorks databases in SSMS.

And then I would like to create a snapshot for AdventureWorks2008 as follows:

use master

go

create database AdventureWorks2008_ss

on

(name=AdventureWorks2008,

filename='C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\data\AdventureWorks2008_ss.ss')

as snapshot of AdventureWorks2008

But I got wrong message: The file 'AdventureWorks2008' does not exist in database 'AdventureWorks2008'.

I already tried to create snapshots for other databases, they worked well. Just databases as to samples can not work.

Is there any way to fix it?

Thanks a lot in advance

Tonny

Answer 1

Try use the logical name of your existing AdventureWorks2008 database where you have name. Check for this by right clicking your AdventureWorks2008 database -> properties -> files e.g. it may say AdventureWorks2008_Data and therefore you would use

create database AdventureWorks2008_ss

on

(name=AdventureWorks2008_Data,

filename='C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\data\AdventureWorks2008_ss.ss')

as snapshot of AdventureWorks2008

 

Answer 2

Done! Thank you!