Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AnnaM
Starting Member
2 Posts |
 Posted - 2011-02-03 : 05:06:15
|
| Hallo,I'm using SSMS 2008. I've defined a maintenance plan and choosen the option to generate a text file report. Works fine if the report is written to c:\temp, but when I choose p:\mssql\backup I get an error message in the log of the maintenance plan: "Access on path p:\\mssql\\backup\\....txt denied."MSDN Library says "You can select directories only on the instance of SQL Server running the maintenance plan." Is this the problem? If so, how can I add my directory to the SQL Server?By the way, the backup files are written into p:\mssql\backup without any problem!Thanks in advance for any help!Regards,Anna |
|
|
AnnaM
Starting Member
2 Posts |
Posted - 2011-02-03 : 08:17:36
|
Well, actually you only have to read the error message - the SQL Server needs to have to have access to the given directory, then everything works fine...  |
 |
|
|
|
|
|
Maintenance plan: location of report files