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 |
|
johno12345
Starting Member
1 Post |
 Posted - 2011-09-19 : 07:07:58
|
| Hi All,I'm new here so please don't flame, and appologies if this has already been covered.I'm fairly amateur with MS SQL, however I'm fairly proficient in SQL and comfortable around a MS operating system.I've been having this issue with SQL Server 2005 where whenever I setup a maintenance plan to perform a full backup it seems to go all screwy. Now i'm 99% sure its something I'm doing wrong.I've created a plan to run every sunday to perform a full backup on a particular set of databases, and a plan to run a daily diff on these same databases.The diffs seem to run OK, but when the full backup runs, 2 of the databases end up being inaccessible with the error when i try take the things offline and back on again that the files were inaccessible and had completely the wrong filename (snapshot and date stamp being in there somewhere)Any ideas where I'm going wrong?I'm just looking to have a really simple backup process.Thanks |
|
|
chris_cs
Posting Yak Master
223 Posts |
Posted - 2011-09-19 : 08:34:09
|
| Can you provide the actual error message you get?Junior DBA learning the ropes |
 |
|
|
|
|
|
Maintenance Plan disconnects files