CODEWITHSUNDEEP
.netsql-serversql-server-2005
subeer haldar
subeer haldar

Reputation: 137

Backup of server database to local machine

I need to backup of my server database to my local machine, i go through previous question asked in SO Create Sql Server Backup on Local Machine which is quite helpful, but still i am not able to take backup of DB.
it said backup is complete. but nothing was there in my Machine. May be my drive is not in Mapping, which is mentioned in second point in that question.
what should i have to do, please suggest me.

Upvotes: 0

Views: 1621

Answers (3)

p.campbell
p.campbell

Reputation: 100567

Try this:

  • create a share on your machine; say to directory d:\dbbackup. Allow it to be written to by the Everyone account. Let's call the share "dbbackup". It's now \\yourMachine\dbbackup. Confirm you can read and write to this share from your server via Windows Explorer.

  • run this in SSMS:

BACKUP DATABASE YourDatabase
  TO DISK = '\\yourMachine\dbBackup\YourDatabase.BAK';
  • your backup is now on \\yourMachine\dbbackup

Upvotes: 1

M.R.
M.R.

Reputation: 4827

If you are connecting to a remote server - which I believe is the case - when you select drive options, it is showing you the drive options on the 'server', not your local machine. So whatever you chose (or even the default one) will get saved on the server, not your local machine. Try looking for the backup file on the server in the directory you chose.

If your local machine is on the same network as the remote machine, you can use the script in the other question and backup. You can also map the drive on the remote machine, and then it should be available for you to choose (if you are using the GUI).

Upvotes: 1

Avisra
Avisra

Reputation: 740

Subeer,

When you backup a SQL Server database, it goes in an awkward spot by default. Typically, you can define this path.

However - check here: C:/Program Files/Microsoft SQL Server/

In there should be a MSSQL folder or possibly MSSQL10.SQL2008EXPRESS (depends on what version of SQL SERVER). Open that, and inside should be a "Backups" folder.

Upvotes: 0

Related Questions