1

How to take backup of SQL Server 2008 system to local client system?

Please give procedure

Improve this question
2
  • Do you need to do this programmatically, if so, on what language/platform? Commented Feb 16, 2011 at 9:55
  • You cannot backup a SQL Server to your local directory directly - you need to put the backup onto a drive connected to the SQL Server machine, and then copy it. Commented Feb 16, 2011 at 10:27

3 Answers 3

Reset to default
1

This link will give you a guide as to what options/parameters are available for backing up your database.

And this link will tell you what you need to do. Example A shows you how to back up to a drive and directory.

Improve this answer
Sign up to request clarification or add additional context in comments.

3 Comments

OK. but i want how to take backup server to client system directly
Copy it to a network drive where both machines have access to. Then, copy to your local client from the network drive. Then you can do a restore from there.
@saran: you CANNOT do a backup from a SQL Server directly to your local workstation - it just CANNOT be done.
1

I think it can be done in this way:

  • Pre: There is SQL Server installed somewhere in company (SQL1)

    1. Install SQL Server Express on your local machine (SQL2)
    2. Install SQL Server Management Studio (SSMS) Express on your local machine
    3. Start SSMS and connect to SQL1 and check the structure
    4. Start SSMS and connect to SQL2 and create same structure
    5. Start Importing Tool, select SQL1 as source and SQL2 as destination and import all data you need
    6. Now you can make an update of your local SQL Server (SQL2)
    7. Finished

Perhaps this is useful.

Improve this answer

Comments

0

It's possible, but it's awkward and you might not have the permissions you need to do it anyway. In most environments, it's a lot easier to do what others have suggested: make a backup on the server itself or to a file server, then copy the file from that location to your workstation.

But if you absolutely have to do it and if you have the right permissions (and network access) then you can do it as follows:

  1. Create a share on your local workstation
  2. Give the necessary share and/or NTFS permissions to the MSSQL service account
  3. Use the BACKUP command with the UNC path to the share

More details about permissions and backing up to UNC paths are in the documentation.

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.