Need Snapshot for Analysis

  • I am having one sql server where I need to analyze data. Bad part is that I am authenticated to connect to this server only for one hour each day. Because of more connections I am asked to do my work within that time only. I don't need recent data for this work.

    I am asked not to create any backup as this would cause server slow. I want to create one snapshot and then take this snap shot file and attach to my server. Is this possible? What precautions should I take when I do this?

    -Lucky

  • I am asked not to create any backup as this would cause server slow. I want to create one snapshot and then take this snap shot file and attach to my server. Is this possible? What precautions should I take when I do this?

    Dtabase snapshot works only on the server where the source database resides. You cannot detach and attach to your local server like a normal database.

    [font="Verdana"]Thanks
    Chandra Mohan[/font]

  • But this creates the file in the hard disk. Do you mean that this file is not useful in any of other servers?

    -Lucky

  • Exactly. You cannot copy these files. Even though if you copy to any other server with any third party utilities also it cannot be attached to any other server.

    Database snapshot is available in enterprise edition for 2005.

    Check this link for more information

    http://msdn.microsoft.com/en-us/library/ms189940(SQL.90).aspx

    [font="Verdana"]Thanks
    Chandra Mohan[/font]

Viewing 4 posts - 1 through 3 (of 3 total)

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