In my SQL Server 2000, I have a particular database that I would like to stop it immediately after I backup that database. What I would like to do is to restore that backup file to a new SQL Server 2008 machine, so the application used to connect to
the SQL Server 2000 db can connect to the SQL Server 2008 db. The connection for the application connected to the SQL Server 2000 db is using the IP method(e.g., 192.168.X.X).
How do I do the backup then stop that database job in SQL Server 2000?
Thanks for help.
View Complete Post