Cannot Delete Database History

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

Data Corruption Issues

Cannot Delete Database History

Author

Topic

pencilman
Starting Member

1 Post

Posted - 2011-07-08 : 13:35:32

Hi,

I am trying to delete a database but cannot seem to delete the history. I can create a new database from the software but it seems the history file is preventing me from accessing the database to upgrade to a newer version.

We have had power interruptions and this caused the database corruptions.

SQL 2005 Error Msg 5242

Database name: SBO-COMMON

Your help will be much appreciated.

Thanks

Jacques

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-07-08 : 13:45:22

You'll need to expand on "database corruptions". Does DBCC CHECKDB return errors for any of the databases (system and user dbs)? If so, you'll need to post the entire output.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-07-08 : 14:01:31

Databases don't have a history. What history file are you talking about?

--
Gail Shaw
SQL Server MVP

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-07-08 : 14:45:03

Yeah I was confused by that too, assumed the OP must be referring to the backup history in msdb.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources