Server Database Backup

  • I want to take backup of my server database at my local machine........ how can i do this......

    Thanks in advance

  • EDIT - Double Post.



    Pradeep Singh

  • vaibhav.a (7/20/2009)


    I want to take backup of my server database at my local machine........ how can i do this......

    Thanks in advance

    By running BACKUP DATABASE

    i'd suggest you read BOL on how to backup a database.

    see here



    Pradeep Singh

  • No, actually i want to take it from my local machine only........we are connected to server.........without altering any settings at the server side......

  • vaibhav.a (7/20/2009)


    No, actually i want to take it from my local machine only........we are connected to server.........without altering any settings at the server side......

    You can take database backup from anywhere(client or server). If you provide a local path to backup a database, it's local to the server not the client.(means the backup will be stored on the server itself)

    If you want you backup on your local machine. there are two ways.

    1. backup database on server. Copy the backup file to your local machine

    2. backup database using a shared path pointing to your client(of course, you need a shared folder on client's machine)

    backup database mydb to disk='\\myMachine\myBackupFolder\myDB.bak'



    Pradeep Singh

  • ps (7/20/2009)


    2. backup database using a shared path pointing to your client(of course, you need a shared folder on client's machine)

    backup database mydb to disk='\\myMachine\myBackupFolder\myDB.bak'

    That will only work if the service account that SQL is running under has full read and write permissions on that share and folder.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Thanks Gail 🙂



    Pradeep Singh

  • And, if you're backing up a production system, if that system is using differential backups, you should backup using the COPY ONLY option so that you're not interferring with the chain of backups on the production system.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply