Backup SQL Server 2005 Database to a different physical server
Posted on 2011-10-04
Is it possible to manually backup a sql server 2005 database to a different physical server? We are trying to migrate to a new virtual sql server, but can't get the sql backup file to copy because it's so large (70gb). I've tried everything that I know how to do to get it copy and it's not working. So I thought I would map a drive on the current sql server to a drive on the new virtual server. I see the drive and can access it from the current server, but when I go to do a manual backup, that drive isn't listed. Any suggestions?