Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Richard101
Starting Member
30 Posts |
 Posted - 2008-01-14 : 07:52:54
|
| Hi AllI want to move a SQL2000 instance off a single server onto a cluster. Question: Can I use Log-Shipping (which is already in use on the single server for DR) to build and populate the tables on the cluster etc (like replication), or do I need to pre-create tables, users etc? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-15 : 23:54:20
|
| If you can have down time and db is not too big, you can just do backup/restore while repointing apps to new server. |
 |
|
|
Richard101
Starting Member
30 Posts |
Posted - 2008-01-16 : 05:12:22
|
| Indeed, backing-up to a SAN, then restoring to the cluster would be my plan-a. But this customer forwarded the notion of using log-shipping (perhaps to avoid downtime?). It seems a long-shot to me, my little knowledge of log-shipping is that only the t-logs are shipped IE: updates. However I have done something similar with transactional replication (which I know more about) IE: deleting a whole database and getting replication to create and populate the tables etc. |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-01-16 : 05:53:34
|
| To start log-shipping, you would first need to back-up and restore the DB anyway, the only advantage there is that the DB is still available to the customer.As long as the objects do not change in the mean-time, this can be completed with log-shipping if you require a minimum downtime. You will have to consider how long it will take to change any connection strings you may have to the old server though and see if it is worthwhile. I would say it would mainly depend on how large a database we are talking about. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-17 : 00:00:58
|
| Careful with replication, it'll change table schema with default snapshot. |
|
|
|
|
|
|
moving an instance using log-shipping.