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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Do u mean path should like
path = \\serverb\share$
Is it correct?
Thank you
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.
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.
Correct on the path the dollar sign would set the share as hidden.
ASKER
ID: 32992951
Diidnt get!! please can u explain what did u mean?
Diidnt get!! please can u explain what did u mean?
ASKER
I am using Microsoft.SqlServer.Manage ment.Smo namespace
Which property specify backup to overwrite previous not append it?
Thank you
Which property specify backup to overwrite previous not append it?
Thank you
I guess you are looking for the backup.initialize property:
http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.backup.initialize(v=sql.105).aspx#Y0
http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.backup.initialize(v=sql.105).aspx#Y0
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
ASKER
Thank you