var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Moving a SQL7 database to another SQL 7 server
Just want to check our procedure with you guys before doing this later tonight.
We are going to dump our database to disk using the backup function, copy the backup file to the new server and restore it into a database we create.
What I am concerned about is anything that could get left behind that we might have overlooked. We are using NT authentication so no user accounts to worry about.
Are there some checks we should do on the database after it has been moved? Any permissions problems we could encounter? Is there a 'best practice' approach to moving databases?
Not being an expert I want to cover all the bases as much as I can and seek a little expert advice :-)