Link to home
Start Free TrialLog in
Avatar of mk39
mk39

asked on

backup database to remote server

Hi,

Is it possible to backup database on remote server; exmpale: server1 has database, I want to have its backup should be placed on server2 c drive test folder?

Thank you
SOLUTION
Avatar of BlakeISS
BlakeISS

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mk39
mk39

ASKER

How to create a hidden share, please tell me more.

Thank you
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mk39

ASKER

Do u mean path should like
path = \\serverb\share$

Is it correct?

Thank you
Hi,

Yes you can do it but, make sure the remote back folder is shared with proper rights to that folder.

Otherwise backup to local drive and copy it to remote location.
mk39
Correct on the path the dollar sign would set the share as hidden.
Avatar of mk39

ASKER

ID: 32992951

Diidnt get!! please can u explain what did u mean?
      
Avatar of mk39

ASKER

I am using Microsoft.SqlServer.Management.Smo namespace

Which property specify backup to overwrite previous not append it?

Thank you
ASKER CERTIFIED SOLUTION
Avatar of DBAduck - Ben Miller
DBAduck - Ben Miller
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.