Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Creating a Database Snapshot. Expand / Collapse
Author
Message
Posted Wednesday, May 6, 2009 10:48 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, October 8, 2014 3:53 PM
Points: 28, Visits: 311
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
Posted Wednesday, May 6, 2009 11:17 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, August 8, 2014 7:43 AM
Points: 92, Visits: 221
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