Copy SQL Server Databases Remotely

How do I copy one database on one server to the next? I am开发者_JS百科 using SQL Server 2005. In the past I used Tasks -> Backup then Restore to the new database. But my server with the database is full and I can't delete anything and SQL Server only appears to allow backups to the local machine.

Is there an easy way to do this?

You can just make the backup using T-SQL directly on a network share:

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

If you prefer to use SQL Server Management Studio: that's possible as well, but not as easy as the T-SQL version,

Take a look at this:

• Backup and Restore SQL Server Database to a network shared drive
• SQL Server backup and restore to network drive