Sunday, February 19, 2012

"How to" apply Snapshot manually

We would like to complete the setup of a new SQL Server in our Data Center.
However, we need to establish a new subscriber for a 13GB database.
After reading various Internet sites and searching these forums, I cannot
find the answer for the following questions:
1) What does the "Snapshot file" look like? Is it a file or a folder?
2) Can someone provide a link or step-by-step info how to "manually" apply
the snapshot once copied to the new server?
TIA
Brent
It is a file. Right click on your publication and select explore snapshot
folder. It should open up and show you the files involved.
To see the commands, look at the output of sp_browsereplcmds. The commands
used begin with sync. You will be unable to use these but they will show you
the order to run them in. You can then run them manually using QA and bcp.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Berb" <berb1969@.earthlink.net> wrote in message
news:FE77293B-DB10-46D0-B2EB-9B7BFD0164E5@.microsoft.com...
> We would like to complete the setup of a new SQL Server in our Data
> Center.
> However, we need to establish a new subscriber for a 13GB database.
> After reading various Internet sites and searching these forums, I cannot
> find the answer for the following questions:
> 1) What does the "Snapshot file" look like? Is it a file or a folder?
> 2) Can someone provide a link or step-by-step info how to "manually" apply
> the snapshot once copied to the new server?
> TIA
> Brent

No comments:

Post a Comment