Problems in creating database snapshots

  • Hi all,

    I am trying to create databse snapshots in my database through T-SQL. But it showing as 'Database Snapshot is not supported on Standard Edition'. But SQL server managemant studio is showing a folder database snapshots under database. Please advice.

    Thanks in advance.

    Ryan
    //All our dreams can come true, if we have the courage to pursue them//

  • sumanta.roy52 (5/11/2009)


    Hi all,

    I am trying to create databse snapshots in my database through T-SQL. But it showing as 'Database Snapshot is not supported on Standard Edition'. But SQL server managemant studio is showing a folder database snapshots under database. Please advice.

    Thanks in advance.

    You can create Database Snapshots only in Enterprise edition. Its a sepearte folder that is maintained by the SQL server when you create database snapshots.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply