Asked by:
Excessive snapshot size causing failure

-
Hi,
I am searching for an explanation of a replication snapshot being in excess of 5 times what we're predicting
Following a replication failure we are attempting to reinitialise subscriptions with a new snapshot. The size of the database is 135GB, one table within the database is 60GB - we have excluded this article from the publication. This meant we had an expectation of snapshot size being ~75GB.
We've had several attempts at creating the snapshot and these have failed due to lack of disk space. Last night the snapshot filled a disk with 340GB of free space.
I 'd welcome any explanation for this huge size of snapshot.
In my examination of possible causes I note that the snapshot format is set to "Character - Required if a publisher or subscriber is not running SQL Server". This despite the fact that at both ends of this transnational replication is native SQL Server. Is there a different in size between formats?
Thanks in advance.
Question
All replies
-
Hello,
Sorry for delay.
You can refer to the following articles about difference between Native Format and Character fromat when bulk exporting data.
http://technet.microsoft.com/en-us/library/ms191232.aspx
http://technet.microsoft.com/en-us/library/ms190919.aspxAs for huge size snapshot, you can try to compressing snapshot file or initialize the subscription from a backup.
Regards,
Fanny LiuIf you have any feedback on our support, please click here.
Fanny Liu
TechNet Community Support -
-
Use the initialize from a backup option.
looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941