sql 2005 maintenance plans

[paulovey]

Hi,

I hope someone can help.

Is there a way to point the .bak file in a sql maint plan to a mapped drive or a remote UNC path in SQL 2005.

Thanks,

Paul


If aint broken, dont try n fix it!!!!!

 

[paulovey]

Yes, you can..

Please ignore post!

Wish I could give myself a *!!!!

If aint broken, dont try n fix it!!!!!

 

[SQLBill]

Why would you give yourself a star? You didn't post a solution to the problem.

Please post your solution as it might help someone else in the future.

-SQLBill

Posting advice: FAQ481-4875

 

[paulovey]

OK the fix was simple in the end.

1. Create a folder and share on the target server
2. In the maint plan point the backup to the share

ie. \\servername\sharename



If aint broken, dont try n fix it!!!!!