Avatar of Carla Romere
Carla RomereFlag for United States of America

asked on 

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?
Microsoft SQL Server 2005

Avatar of undefined
Last Comment
Carla Romere
Avatar of vdr1620
Flag of United States of America image

Avatar of Ephraim Wangoya
Ephraim Wangoya
Flag of United States of America image

Blurred text
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.
See Pricing Options
Start Free Trial
Avatar of BartVx
Flag of Belgium image

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:

Avatar of Carla Romere
Carla Romere
Flag of United States of America image


This worked beautifully. I couldn't get the first one to work at all.
Microsoft SQL Server 2005
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.

Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews


IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo