none
why I can not create a snapshot for AdventureWorks2008

    Pergunta

  • 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

    domingo, 5 de fevereiro de 2012 17:10

Respostas

  • 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

     

    • Marcado como Resposta lovesql domingo, 5 de fevereiro de 2012 19:38
    domingo, 5 de fevereiro de 2012 19:25

Todas as Respostas

  • 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

     

    • Marcado como Resposta lovesql domingo, 5 de fevereiro de 2012 19:38
    domingo, 5 de fevereiro de 2012 19:25
  • Done! Thank you!
    domingo, 5 de fevereiro de 2012 19:38