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.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Maintenance Plan disconnects files

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
Go to Top of Page
   

- Advertisement -