|
Home > Archive > MS SQL Server DTS > March 2006 > Scheduling database copy
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Scheduling database copy
|
|
|
| Server: SQL2K
I want to have a backup server ready to deploy in case my production server
gets damaged. One of tables has identity column, and the other has no
primary key. So, I gave up Replication method. (Does Replication still
work?)
I chose DTS to copy database. When the backup server didn't have the user
database, I could copy database successfully. Now, the backup server has
already database, DTS Export doesn't work.
Can anybody recommend how to create the exactly same database on backup
server?
Thank you very much in advance.
| |
| Andrew J. Kelly 2006-03-31, 8:26 pm |
| You can use Log shipping to keep the two in relative sync with each other.
Check out Log shipping in BooksOnLine and Google for more details.
--
Andrew J. Kelly SQL MVP
"hb" <hb@discussions.microsoft.com> wrote in message
news:EED9AB4D-148B-4E1B-AF68- 7D0738AE5D01@microso
ft.com...
> Server: SQL2K
>
> I want to have a backup server ready to deploy in case my production
> server
> gets damaged. One of tables has identity column, and the other has no
> primary key. So, I gave up Replication method. (Does Replication still
> work?)
>
> I chose DTS to copy database. When the backup server didn't have the user
> database, I could copy database successfully. Now, the backup server has
> already database, DTS Export doesn't work.
>
> Can anybody recommend how to create the exactly same database on backup
> server?
>
> Thank you very much in advance.
|
|
|
|
|