SQL Server 2005 is screwing up my SharePoint backups?!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Conrad Goodman - 10 Jul 2008 10:39 GMT

I have SQL Server 2005 and SharePoint Server 2007 installed on a single box.

The problem I am having is with SharePoint backups, they fail claiming that
another tool carried out the last back up.

It appears that at 10PM every night, SQL Server backs itself up some how.

I am a complete newbie to SQL Server, I've literally just installed it and
let it sit there.

Is there a default backup schedule I can modify to prevent this from
happening?

Thanks

Conrad

Reply to this Message

Tibor Karaszi - 10 Jul 2008 10:54 GMT

> It appears that at 10PM every night, SQL Server backs itself up some how.

Not by default.

> Is there a default backup schedule I can modify to prevent this from happening?

No. Check if you have any SQL Server Agent jobs, and if so any of those do this backup. If not, then
this happens from outside your SQL Server.

Signature

Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

>I have SQL Server 2005 and SharePoint Server 2007 installed on a single box.
>
[quoted text clipped - 10 lines]
>
> Conrad

Reply to this Message

Uri Dimant - 10 Jul 2008 11:00 GMT

Conrad
You can create a maintanence task to backup all user databases or using
T-SQL BACKUP DATABASE commamd traverse trou all user database.
Im my experience , running SQL Server production along with SharePoint is
one big mistake. In terms of databases SP is disaster that hits performance
and its databases heavily involved in deadlocks which I'm not able to fix
http://dimantdatabasesolutions.blogspot.com/2008/06/how-do-you-maintain-sharepoi
nt.html

>I have SQL Server 2005 and SharePoint Server 2007 installed on a single
>box.
[quoted text clipped - 13 lines]
>
> Conrad

Reply to this Message