how to take database backup without ssms for remote server

Posted by Parthibansk under Sql Server on 5/16/2013 | Points: 10 | Views : 933 | Status : [Member] | Replies : 1
i couldn't create backup for remote database..i tried using backup and generate scripts..but both failed..

ERROR: user does not have permission TO CREATE BACKUP..

IS THERE ANY WAY TO CREATEBACKUP?




Responses

Posted by: Raj.Trivedi on: 5/16/2013 [Member] [MVP] Starter | Points: 25

Up
0
Down
Try copying the .mdf file from the remote machine.

Regard's
Raj.Trivedi
"Sharing is Caring"
Please mark as answer if your Query is resolved

Parthibansk, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response