Geek asks and answers

Copy SQL Server Databases Remotely

How to copy one database on one server to another? I am using SQL Server 2005. In the past, I used Tasks → Backup and Restore for a new database. But my database server is full, and I can’t delete anything, and only SQL Server allows backup to the local machine.

Is there an easy way to do this?

+1
source share
1 answer

You can simply backup using T-SQL directly to a network share:

BACKUP DATABASE MyDatabase TO DISK = '\\AnotherServer\SomeShare\MyDatabase.bak'

If you prefer to use SQL Server Management Studio: it's possible, but not as simple as the version of T-SQL,

Take a look at this:

+2

More articles:


All Articles