http://www.sqlvillage.com/Articles/Backup%20Operation%20failing%20after%20Database%20Upgraded%20from%20SQL%20Server%202000%20to%20SQL%20Server%202008.asp Bong Robles Marked as answer by Shulei ChenModerator Thursday, August 23, 2012 1:26 AM Wednesday, August 22, 2012 3:25 PM Reply | Quote All replies 0 Sign in to DB worked fine, checkdb didn't report anything. Do I need to cite an old theorem, if I've strengthened it, wrote my own theorem statement, with a different proof? ksql32 Starting Member 15 Posts Posted-04/30/2008: 08:57:14 It is SP2 - and if by disabling you mean going through the properties and disabling, then yes. http://lanprolab.net/error-occurred/an-error-occurred-while-processing-the-log-for-database.php
Viewable by all users Your answer toggle preview: Attachments: Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total. Cheers, Jai admin - November 13, 2012 yes please keep me informed, and good luck with you! thank you more ▼ 0 total comments 414 characters / 71 words asked Nov 18, 2011 at 03:42 AM in Default Angeli 23 ● 4 ● 5 ● 6 edited May You cannot upload attachments. https://social.msdn.microsoft.com/Forums/sqlserver/en-US/318d0d4c-2ed7-4aca-becb-89f462e84460/an-error-occurred-while-processing-backupmetadata-metadata-for-database?forum=sqldisasterrecovery
GilaMonster Flowing Fount of Yak Knowledge South Africa 4507 Posts Posted-12/27/2009: 15:50:50 quote:Originally posted by sven2When I run the command dbcc check db I get 2 lines where My Blog | Hire MeProposed as answer by Shulei ChenModerator Wednesday, August 22, 2012 9:52 AM Tuesday, August 21, 2012 1:39 PM Reply | Quote 0 Sign in to vote If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.Would you like to participate? I'm not sure about file ids, but Full Text Catalogs seems to start on id 65537. Since I didn't need the Full Text Catalog I just droppped it and backups started to work again.
If I use just "backup database production," I get a similar error:Msg 3636, Level 16, State 2, Line 1An error occurred while processing 'BackupMetadata' metadata for database id 5 file id Meantime, ignore the instructions from MS Escalation Engineers in the post, those are for collecting data and really didn't help at all. -raymond Raymond Yu's Technology Network » How we addressed named pipes is enabled. A Database Error Occurred While Processing This Request I tried disabling full-text indexing and re-running, but I got the same error.
FULL BACKUP IS NOW WORKING!!!!! You cannot post HTML code. Here are some other things I tried after I dropped the catalogs:I've detached and reattached, again making sure to not keep the catalogs.I tried taking the db offline, copying the files, How did upgrade the database?
When copied to the SQL 2008 R2, full Control Permission was given to user (w/ admin priv) as DB cannot be attached initially due to Access Denied. Thread Tools Rating: Display Modes 12-23-2009, 03:50 AM #1 sven2 Newly Registered User Join Date: Apr 2007 Posts: 297 Thanks: 0 Thanked 0 Times in 0 Posts Database backup All Forums General SQL Server Forums Data Corruption Issues Restore database Reply to Topic Printer Friendly Author Topic sven2 Yak Posting Veteran Belgium 57 Posts Posted-12/24/2009: 06:49:48 Hello,in Hope it fixes the issue Thanks Again.
Privacy statement © 2016 Microsoft. Topic Reply to Topic Printer Friendly Jump To: Select Forum General SQL Server Forums New to SQL Server Programming New to SQL Server Administration Script Library Data Corruption Issues Database An Error Occurred While Processing The Log For Database We've restricted the ability to create new threads on these forums. An Error Occurred While Processing The Log For Database If Possible Restore From Backup rmiao Flowing Fount of Yak Knowledge USA 7266 Posts Posted-04/29/2008: 22:17:20 You disabled full text index on the db?
Thanks for the tips Janos. have a peek at these guys I was also trying to Enable Full Text Index but it won't get enabled on my SQL R2 server. You can try to turn auto_close off by using the following code: Alter database
Or do you think I have to check some more issues?Best regards,Sven. How are you trying to backup?You could use the generate script option from management studio (assuming this is 2005/2008). Thanks in advance, Sven. check over here I also tried this code which I found also in one of the forums: IF EXISTS (SELECT * FROM sys.fulltext_indexes fti WHERE fti.object_id = OBJECT_ID(N'[dbo].[ContinousCaseNotes]')) ALTER FULLTEXT INDEX ON [dbo].[ContinousCaseNotes] DISABLE
Things to consider when you troubleshoot the 3041 message: Does the problem occur for just one database or for all databases?Is the backup taken to local storage or to remote storeage?What Tried drop catalog in ssms? Username: Password: Save Password Forgot your Password?
Database i currently using do not have fulltext Index option enbaled. And if not, how do I get to change this so that the files are back online. BACKUP DATABASE is terminating abnormally.". Some other background details that may be relevant:I checked the location of the catalogs and noticed that the location doesn't exist on the server!
Can't risk removing filestream objects if it will invoke data loss. Mohan Kumar. You may download attachments. this content You cannot post topic replies.
I have tried exactly same steps you have tried and I couldn't solve the issue (havent tried the MS option you mentioned above though). Follow theseinstructionsto enable filestream:http://msdn.microsoft.com/en-us/library/cc645923(SQL.105).aspx JanosThere are 10 type of people. The database has been attached without the Full text catalog option and select * from sysfulltextcatalogs fetches no results. You cannot delete other posts.
Those who understand binary and those who do not. Do you have any recently full backup of your DB? After much searching I am at a loss as to why. FULL BACKUP IS NOW WORKING!!!!!
Moved by Shulei ChenModerator Monday, August 13, 2012 1:43 AM (From:SQL Server Tools) Friday, August 10, 2012 7:59 AM Reply | Quote Answers 0 Sign in to vote After trying different If so, revome it then try backup again.