MartyS


Hello,

We're new users of SQL Server 2005. I created two maintenance plans...one to backup the database at 2 AM daily and one to back up transaction logs every 30 minutes. These maintenance plans write to a local disk. What we want to do, within the maintenance plan, is copy the files as soon as they are written to a remote server. Is that possible

Thanks in advance.




Re: Copy files after backup in maintenance plan

Deepak Rangarajan


Create a shared folder in the remote server and specify the path in the maintenace plan so that the backup will directly fall in the remote server. You need to ensure that the sql startup account should have modify privileges to the shared folder in remote server for the maintenance jobs to succeed !..........

else you can also add a job step in maintenance jobs using xcopy command to copy the files to remote server.

Thanxx

Deepak







Re: Copy files after backup in maintenance plan

Madhu K Nair

Maintenance Plan is nothing but a SSIS (Integration Services) project. What u can do is open the MP in BIDS (business intellegence Development studio) ENV and add a *File System Task* and make the requried changes.

Madhu







Re: Copy files after backup in maintenance plan

MartyS

Thank you both for the fast replys....

From what I can tell, the maintenance plans are stored in the database. However, when I go into BIDS the file/open is only for OS files. What do I need to do to open the maintenance plan in BIDS

Thanks again in advance!





Re: Copy files after backup in maintenance plan

Vidhya Sagar

Hi Marty,

Go to BIDS--> create a New project -- > Open the project.

In solution explorer you can see "SSIS packages" folder --> Right click on the folder

Select "Add existing package"

Mention the servername & Authentication mode in the window then you can select the maintainence plan you have created.






Re: Copy files after backup in maintenance plan

MartyS

Excellent...thank you so much




Re: Copy files after backup in maintenance plan

mxkieran

you can also add a job by going to SQL Agent->Jobs in SQL Mgmt Studio. The type of job would be "command exec". Then edit your maintenance plan to add the job. That way you can do everything within SQL Studio (if you didn't want to use BIDS).