Home » Topic » Creating Database Snapshot

Creating Database Snapshot

Lincoln Burrows ~ Modified: March 12th, 2016 ~ ~ 1 Minute Reading

Home Forums Creating Database Snapshot

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #1561 Score: 0
    Lincoln Burrows
    Moderator
    16 pts

    Hi to all,

    If want to create a snapshot in SQL Server database then what should we care? How can we create a snapshot in a SQL Server database?

    #1567 Score: 0
    Stephen West
    Moderator
    4 pts

    First of all you should ensure that you have sufficient space on your disk drive to hold the database snapshot. You can create a database snapshot only the help of TSQL command. The SQL Server Management Studio doesn’t provide the facility to create the database snapshot.
    Here I have posted a sample query to create the database snapshot.

    CREATE DATABASE database_snapshot_name 
        ON
        (
            NAME = logical_file_name,
            FILENAME = 'os_file_name' 
        ) [ ,...n ]
        AS SNAPSHOT OF source_database_name
    [;]
    #1606 Score: 0
    Lincoln Burrows
    Moderator
    16 pts

    What are the benefits of using a snapshot in SQL Server database and what are the limitations of a snapshot in SQL Server databases? Please suggest.

    #1694 Score: 0
    Andrew Jackson
    Moderator
    1 pt

    There are several benefits of a database snapshot in SQL Server. Here I have discussed some of them:
    1. The database snapshots can be used in reporting services.
    2. Works as a safeguards against administrative error.
    3. Also can be used in managing the test database.
    4. Can be used as mirror database that you can use for maintaining for availability purposes.

    Some limitations are like:
    1. Snapshots are read-only.
    2. specifications of the database snapshot files are not changeable.
    3. You cannot attach or detach database snapshots.
    To know more please go this one it may be helpful to you https://msdn.microsoft.com/en-us/library/ms175158.aspx

Viewing 4 posts - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.