Backup SQL Server 2005 Database to a different physical server

Posted on 2011-10-04
Last Modified: 2012-05-12
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?
Question by:Hers2keep
    LVL 16

    Expert Comment

    LVL 32

    Accepted Solution


    Do it with a query from the sql window

    BACKUP DATABASE [MYDATABASE] TO DISK = '\\servername\c$\SQLServerBackups\mydatbase.Bak'
    LVL 3

    Expert Comment

    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:

    Author Closing Comment

    This worked beautifully. I couldn't get the first one to work at all.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    Suggested Solutions

    I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
    When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    This video discusses moving either the default database or any database to a new volume.

    731 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now