Backup SQL Server 2005 Database to a different physical server
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?
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
You can back up a database to a network share but should pay attention to security rights. See the ''Backing Up to a File on a Network Share section in following MSDN link:
http://msdn.microsoft.com/en-us/library/ms179313(v=SQL.90).aspx
http://msdn.microsoft.com/en-us/library/ms179313(v=SQL.90).aspx
ASKER
This worked beautifully. I couldn't get the first one to work at all.
Microsoft SQL Server 2005
Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.
72K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
http://blogs.msdn.com/b/sqlserverfaq/archive/2009/02/27/how-to-backup-sql-server-databases-to-a-mapped-drive.aspx