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'