If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: How to take a back up?

Hi guys,
i want to know how to take a back up. i have everything in server and i am accessing database in server. whenever i am takign backup, it is getting saved in the server instead of local computer. i.e c, d, or e drive. Please let me know how to take a back up from the database which runs in server into the local system.

Be sure you have enough free space on the local drive that you are backing up to. A screen shot of the error you receive would be beneficial to those trying to help. As Pootle said, without a definition of "not working", we really can't offer much constructive help.

Yes it does sound like op is trying to backup a remote DB. Without any further information about what isn't working 'at all' the amount of help you will get will be limited.

Just keep in mind follow best practices and that should help. It's a general answer, but the details of the issue are general. As multiple people have said, backup locally, then offload those backups somewhere else.

As a side note, I often see people buying expensive agents for backup programs to backup SQL Server databases directly. The best backup program in the world for SQL Server is SQL Server. Backup the database using the native commands, then offload to a share, tape, remote SAN, etc.