Full backup hanging on last step

Hey guys, hopefully someone can help me.

I have a full backup that runs every night. A couple nights ago, it started to hang on on backing up the Windows Sharepoint Services Search Database. It says "Preparing backup" while all the other steps says "In Process". The SQL server database, on the same server (single server deployment) taps out in the morning and the portal is unable to connect to the config database. Then I'd have to restart the server.

These backups are also not restorable as they had never finished.

Does anyone know what's going on here or know how to clear the unfinished backup history? I've already tried deleting timer failed and stuck timer jobs. Thank you much.

[744 byte] By [HenryOng] at [2007-12-30]

«« Changing Domains - Issues with Team Queries and Project Alerts
»» Difference between 2 dates in a database

# 1

I have two sharepoint servers setup with two separate database and both of them failed when trying to do a full sharpoint site backup. One of our servers is just the default install and the other is our production site. We originally though it was due to indexing running in the background for the search, but we tried one without indexing setup and it didn't work either. If anyone knows how to fix this please let me know.

reminvestor at 2007-9-5 >

top of Msdn Tech,SharePoint Products and Technologies,SharePoint - Setup, Upgrade, Administration and Operation...

# 2

I'm not sure how mines started to work again exactly but after installing sql server 2005 sp1 a lot of weird error messages disappeared from my event logs.

HenryOng at 2007-9-5 >

SharePoint Products and Technologies

SharePoint - Setup, Upgrade, Administration and Operation

SharePoint Products and Technologies Hot Topic

SharePoint Products and Technologies New Topic

SharePoint Products and Technologies

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech