How to migrate a database to a new instance

How to migrate a database to a new instanceĀ from SQL 2000 to newer version:

There are many ways to migrate a database to a different server (detach-attach, log shipping, etc) but this routine outlines the general considerations.

Find out the best time to migrate the database
Schedule the maintenance window and notify all users
Script all logins, agent jobs

Continue reading […] How to migrate a database to a new instance […]

 

The concept of one-way time travel

SQL Server is a timeless data storage, however time travel is possible one-way only.

Unless you find a backdoor, of course.

Which 'one way' would you like to go?

What I mean by this is, that if you have a database residing on SQL ServerĀ 2000 and you back it up and restore it to a SQL Server

Continue reading […] The concept of one-way time travel […]