I need to copy SQL Server database instance into another server off-site quickly, what is my best option ? is it using Database backup while the server is still online ?
I will need to have stored procedure, logins and all objects that is associated with this particular DB instance.
and also what is the encryption strength if it is possible ?
Note: I'm using SQL Server 2000 Enterprise and would like to migrate this into SQL Server 2008