Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Initialize from backup files.

 
   Database Forums (Home) -> Replication RSS
Next:  Tuning Advisor Crashing in SQL Server 2005  
Author Message
k_s

External


Since: Mar 11, 2005
Posts: 9



(Msg. 1) Posted: Mon Dec 05, 2005 10:47 pm
Post subject: Initialize from backup files.
Archived from groups: microsoft>public>sqlserver>replication (more info?)

Hi,
I have both my server at different location with around 4GB of database and
network is poor.
I am trying this feature of SQl 2005 replication which allows initial
snapshot from backup.
I could do it with pubs db but couldn't understand some points. Expert's
advice will be greatly appreciated.

To my understanding , the initial snapshot flows from publisher to
subscriber (corect me if i am wrong). When I create the subscription I have
to add those 3 valuws to the sp_addSubscription :
@sync_type = initialize with backup.
@backupdevicetype = disk
@backupdevicename = path of the backup file(s).
Why this "@backupdevicename" has to be a path on server side and not
subscriber?

If neone could guide me to an article or link where this is nicely
explained, it'll be great.

I am using 'Replication' for the fisrt time, so the question could be stupid.

Thanks.

 >> Stay informed about: Initialize from backup files. 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
SQLDistribution Initialize Error - With the following code I get the error Method 'Initialize' of object 'ISQLDistribution' failed. The .Status at this time is "Connecting to Subscriber 'MYCOMPUTERNAME' " I have a SQLDistribution Object called sqlDist. The error occurs on the ....

Unable to re-initialize transactional Replication - I have this problem when I re-initialize a transactional replication its still looking for a old snapshot folder. Even after i create a snapshot, its still looking at the old folder. Any way to force it to expire the old snapshot? Any advise is much..

How to activate "Initialize the schema and data by Snapsho.. - Hi All, Since I have the full set of data in Subscriber, I selected "The subscriber already has the schema and data" when setting the transaction replication. However, I find that only the data change in the Publisher will be replicated to Su...

Problem in BACKUP job - Hi, I am using a job to take daily backup. BACKUP DATABASE databasenameTO DISK=N'path' WITH INIT,NOUNLOAD,NAME=N'name', NOSKIP,STATS=10,NOFORMAT and it was working fine. When I tried to restore the backup, I couldn't restore it, the backup was ..

why is the SQL backup filesize so big - Hi, We have an database which is about the file size of 730MB, this db is set configure with publisher and will always push data to our backup server database. When we backup this db, the database backup filesize is actually 85GB (full backup from SQL)...
   Database Forums (Home) -> Replication All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]