Hi ,

I have a sql server 2005 with a number of databases running on it. Now I need to move several dbs from 2000 over to this 2005, what measures will I need to take to ensure that the 2005 box will be able to handle all the dbs and perform normally after the move?

__________________
A.Rajesh Khanna

Hi arjkhanna,

Once you move all your dbs to sql 2005 by either detach/attach or Backup/restore you need to change the compatability of your db to 90 to use all the features of sql 2005 ! (eg. Performance Dashboard needs compatability 90 ) other than that ensure that you have the Recovery models as per your business strategy. Go for Full recovery if you need to have point in time recovery else have it as Simple recovery

__________________
J Suresh Kumar
Google Hacks

Hi jsureshkumar,

May I ask on how to proceed on changing its compatability to 90? Also, are there ways to find out how much resources available on this sql 2005 so that I can be sure that adding these more dbs won't cause it to lock up or stop functioning correctly? I just want to make sure that the server still functions properly after adding more dbs to it.

Thanks again.

__________________
A.Rajesh Khanna

Hi,

sp_dbcmptlevel 'Dbname', 90

execute the above command in SSMS it will change the compatability to 90 else you can also Right click the db and go to the properties and change it as 90. refer sp_dbcmptlevel (Transact-SQL)

Since you add more dbs ensure that there is sufficient disk space and also the RAM,CPU,Disk I/O usage depends on the number of user connections and the operations you perform on the DB

__________________
J Suresh Kumar
Google Hacks