Re: Scheduling database copy
- From: "Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx>
- Date: Fri, 31 Mar 2006 19:24:00 -0500
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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:EED9AB4D-148B-4E1B-AF68-7D0738AE5D01@xxxxxxxxxxxxxxxx
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.
.
- Prev by Date: Re: Keeping object selection when changing login
- Next by Date: Dynamically change data source (connections) thru ActiveX?
- Previous by thread: Re: Keeping object selection when changing login
- Next by thread: Dynamically change data source (connections) thru ActiveX?
- Index(es):
Relevant Pages
|
