Search

August 2005
M T W T F S S
« Jul   Sep »
1234567
891011121314
15161718192021
22232425262728
293031  

Databases cannot be backed up

August 28th, 2005 by

From: “Joshua Campbell”


Subject: Databases can’t be backed up


Date: Thu, 11 Aug 2005 10:17:38 -0400


Newsgroups: microsoft.public.sharepoint.portalserver


 


I have my SPS2003 databases going to a SQL 2000 server.  However, when SQL is trying to do a tran log backup, I get this error:


     Backup can not be performed on this database. This sub task is    


 ignored


 


Anyone seen this and know how to fix it?


 


Thanks.


 


*************************************


 


From: <david.nixon@danix-consulting.com>


Subject: RE: Databases can’t be backed up


Date: Thu, 11 Aug 2005 08:20:21 -0700


Newsgroups: microsoft.public.sharepoint.portalserver


 


 


is sql running in simple mode?


 


*************************************


 


From: “Joshua Campbell”


Subject: Re: Databases can’t be backed up


Date: Thu, 11 Aug 2005 12:32:20 -0400


Newsgroups: microsoft.public.sharepoint.portalserver


 


 


The Recovery Model of those databases does seem to be on Simple. 


Should I change that to Full?


 


*************************************


 


From: dbsearch


Newsgroups: microsoft.public.sharepoint.portalserver


Subject: Re: Databases can’t be backed up


Date: 19 Aug 2005 16:26:50 -0700


 


There is no reason to use anything other than Simple for SPS. I can post the blog about that if you want. So, if you are running with Simple, no need to worry about the tran log.


 


Regards..Roger


 


*************************************


 


Date: Fri, 19 Aug 2005 20:57:50 PST


Subject: Re: Databases can’t be backed up


From: “Hollis D. Paul”


Newsgroups: microsoft.public.sharepoint.portalserver


 


I would like the URL to the blog, if you would please post it.


 


Thank you.


 


*************************************


 


From: dbsearch


Newsgroups: microsoft.public.sharepoint.portalserver


Subject: Re: Databases can’t be backed up


Date: 21 Aug 2005 20:33:45 -0700


 


It took me a while to find this again. Very insightful indeed!


 


http://mindsharpblogs.com/bill/archive/2005/01/14/181.aspx


 


Regards..Roger


 


 


 


 


 

Posted in SPPS03_Tips | No Comments »



Comments are closed.