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 |
|
hallkvist
Starting Member
1 Post |
 Posted - 2008-10-22 : 06:30:19
|
| We’re planning an upgrade of our database environment from SQL Server 2000 to SQL Server 2008. This is done by simply detaching the 2000 database files and attaching a copy in the 2008 server. This works beautifully, but once the files has been attached in 2008, they cannot be reopened in 2000. And if we for some reason have to roll back to the old environment after a day or a week, the old database has to be in sync. What would be the simplest and easiest way to do it? Remember that the two databases are identical and the synchronization should only be active for a short period of time.Are we talking about a lot of triggers? Log shipping? Replication?Thanks in advance,Brian Hallkvist |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-22 : 08:57:43
|
| Why don't you backup all databases for SQL 2000 so that you can restore if you have to? |
 |
|
|
|
|
|
Synchronizing SQL Server 2008 with SQL Server 2000