First I asked my question here: Migrate all databases from one SQL Server 2005 to another
Many friends replied to it and I gathered lots of useful information.
I have another scenario in which we can have some hours of downtime. We want to close the SQL Server port on the firewall, backup the databases, move the backups to new server, restore them on our new server.
It can be achieved by creating backup of all databases including
master DB. But in this case we will have 200
Is there any way to have a general
.bak file including all of the data on our SQL Server? So we will easily restore this big
.bak file in our new server?
Is there any internal option in SQL Server 2005 to restore the whole date on our new SQK Server 2005?
Thank you for your replies.