October 29, 2003 at 7:46 am
How can we copy a database from one server to a different sever which is having replication.Can anyone help me on this issue.
October 29, 2003 at 11:27 am
Can anyone help me in this isuue.
Thanks.
October 29, 2003 at 11:51 am
The simplest way is to use a backup. Then restore the database on the new machine with the MOVE option.
However I'm not sure what you mean by the different server having replication. Can you give us some more specifics?
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
October 29, 2003 at 2:37 pm
I have the database aa on server xxxx. and it has replication with the database aa on server yyyy.Database aa on server xxxx is a subscriber to database on yyyy.Now i want to copy this aa database which is on xxxx onto a new server zzzz.
What should i do to achieve this.
Thanks.
October 29, 2003 at 3:02 pm
I would simply backup the subscriber aa and copy the backup file to the new machine and restore it. This will lose your subscription information so there will be no way to sync the subscription up to the publisher however.
Other than that you can do one of the following.
1 - Sync the data to the publisher and then just create a new subscription on the new machine.
2 - Create a publication on subscriber yyyy and a subscription on zzzz pointing to the new publication on yyyy.
I would say it all depends on how elaborate you want to make it, how much knowledge you have on replication, and what your true business needs are.
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
October 29, 2003 at 3:53 pm
I have the diff backup for the databse on server xxxx.Can i copy the same onto the new server zzzz and restore it on server zzzz.
How can i do this.
Thanks
October 29, 2003 at 11:13 pm
You need to take a look at SQL Server Books Online on the Restore command.
basically
Restore Database <dbname>
FROM DISK = 'filename'
WITH STATS, MOVE...
I don't have BOL here so I can't give you the complete syntax. You need to use the move option unless you have the same disk structure on zzzz that you have on the existing subscriber.
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply