For taking bakup in network location( ie in a client system) in WORKGROUP environment using sql server maintenance plan please do the following.
1. in the server , type services.msc in Run, select MSSQL Server, click on the logon Tab. Deselect Local system Account and Select this account. Type an admistrative user name and password which can access the shared folder in the specified client.
ie., Server Administrator user name and password. For eg:- POSTMASTER, Administrator etc.
Do this for the service SQL server agent also. Stop and restart these services.
Then in the maintanance planGive folder locations as \\client\backup
for eg:- \\mpcm\backup
provided, the folder should be fully shared.
Backup files will be created in the client location at the specified time.
Thanks to Ramachandran SA.
1. in the server , type services.msc in Run, select MSSQL Server, click on the logon Tab. Deselect Local system Account and Select this account. Type an admistrative user name and password which can access the shared folder in the specified client.
ie., Server Administrator user name and password. For eg:- POSTMASTER, Administrator etc.
Do this for the service SQL server agent also. Stop and restart these services.
Then in the maintanance planGive folder locations as \\client\backup
for eg:- \\mpcm\backup
provided, the folder should be fully shared.
Backup files will be created in the client location at the specified time.
Thanks to Ramachandran SA.
No comments:
Post a Comment