You must stop the replication agent before you copy the database to the test server, after that make sure all log file in the production server has been restore in...

You can change it in the service manager, change with your windowsc account.

Dear Andy,

Are you use SQL Server 2000? If yes, you can change the option recovery model in your SQL to Simple (Not Full), but this is can be apply if...

You just need to restore the database to became the online status, by running this script :

restore database (DatabaseName) with recovery

make sure the all log file has been restore (if...

You can create replication and choose the merge replication, because with this you can update the database in 2 side, in DB1 or DB2.

Why you don't use the DTS Task?

Yes, you must rename the server B to A, but if you want to not change the server name, you can change the connection in your application.

Your SQL Server service account must have an access to that PC

My suggestion is, if you have good design in your database schema, go with the replication, because the performance it's depend on you database design.

You can create the network mapping from your OS and create a script backup to that drive

You just need to create one script and you schedule in your sql server job, but in your table must have a column that have a default value, when the...

You has been checking the location of data? the filename of mdf file? Because I guest the file name or the file exist in the folder location where...

I think that's a fastest way to copy database to another server, and have the minimum risk.

In the SQL Enterprise Manager, open table design, right click in the 4th column then click insert

You just need to remove the anonymous access in 2 virtual Directories reporting services