Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hspatil31
Posting Yak Master
182 Posts |
 Posted - 2010-11-11 : 08:31:12
|
| Dear All,Can anybody tell me how to take server database backup on local machine ?Thanks and Regard'sHarish Patil |
|
|
pk_bohra
Master Smack Fu Yak Hacker
1182 Posts |
Posted - 2010-11-11 : 08:58:42
|
| Have a look at:http://www.mssqltips.com/tip.asp?tip=1126 |
 |
|
|
hspatil31
Posting Yak Master
182 Posts |
Posted - 2010-11-11 : 09:11:48
|
| Dear pk_bohra,From where i will get SQL Server Backup window ?Thanks, |
|
|
|
hspatil31
Posting Yak Master
182 Posts |
Posted - 2010-11-11 : 09:15:46
|
| Dear,I am getting following error,TITLE: Locate Database Files - U15409476\U15409476------------------------------c:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\BackupCannot access the specified path or file on the server. Verify that you have the necessary security privileges and that the path or file exists. If you know that the service account can access a specific file, type in the full path for the file in the File Name control in the Locate dialog box.------------------------------BUTTONS:OK------------------------------Thanks, |
|
|
|
pk_bohra
Master Smack Fu Yak Hacker
1182 Posts |
Posted - 2010-11-11 : 11:32:52
|
| Did u created a shared drive on the local machine where you want to have backup copy ?The shared drive path need to be specified in the window |
|
|
|
hspatil31
Posting Yak Master
182 Posts |
Posted - 2010-11-12 : 02:35:55
|
| Dear pk_bohra,Sorry but i am not getting where i have to give the path of share folder.Thanks, |
|
|
|
|
|
|
Server database backup on local machine.