Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » Creating a Database Snapshot.
Add to briefcase

Creating a Database Snapshot. Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
Jose Ianuck
Posted Wednesday, May 06, 2009 10:48 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, May 16, 2013 11:02 AM
Points: 27, Visits: 246
Hi, friends, You were already in this situation, I need to create a database Snapshot, however in the Server doesn't have enough space in disk and, even so the database is created Snapshot usually without mistakes, somebody has some idea why this happens.

Thank´s.

Ian.
Post #711299
Alex Prusakov
Posted Wednesday, May 06, 2009 11:17 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, March 27, 2013 8:55 AM
Points: 92, Visits: 192
Initial snapshot doesn't need any space. Snapshot's size is growing together with data changes because snapshot includes only pages with differences. You can find details at: http://msdn.microsoft.com/en-us/library/ms187054.aspx

Alex Prusakov
Post #711325
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.