My database server is being decommissioned at work. We have a new database server to take its place. Both servers have the same operating system and SQL Server 2008. I need to move all my databases and data over to the new server.
What is the best way to do this to ensure as few problems as possible?
My data is not just tables, views and stored procedures. There are also several SQL Server Agent jobs and several database maintenance plans and scheduled backups.
The system is not being used at night, so I have a late night opportunity to take the database offline, if need be.
Can I just copy the
MSSQL directory over to the new server? Or should I just backup each database individually? If I do backup each database, should I back up the system databases (like