Database 'dbname' cannot be opened because its ver

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

Database 'dbname' cannot be opened because its ver

Author

Topic

asim.khan007
Starting Member

4 Posts

Posted - 2007-04-01 : 12:46:06

i have curputed mdf and ldf file for ms sql 2005

i have tried to put the db in standby mode and when i try to run dbcc checkdb or any other command i get this message

Database 'dbname' cannot be opened because its version (611) is later than the current server version (539).

but without standby mode i get this error

TITLE: Microsoft SQL Server Management Studio
------------------------------

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

Could not find row in sysindexes for database ID 40, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes. (Microsoft SQL Server, Error: 602)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=602&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

asim.khan007
Starting Member

4 Posts

Posted - 2007-04-01 : 12:47:36

aslo i get this message

TITLE: Microsoft SQL Server Management Studio
------------------------------

Cannot show requested dialog.

------------------------------
ADDITIONAL INFORMATION:

Cannot show requested dialog. (SqlMgmt)

------------------------------

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

Database 'alwaqar_clients' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details. (Microsoft SQL Server, Error: 945)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=08.00.0194&EvtSrc=MSSQLServer&EvtID=945&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

paulrandal
Yak with Vast SQL Skills

899 Posts

Posted - 2007-04-02 : 19:58:21

You're trying to attach a SQL Server 2005 database to a SQL Server 2000 server - this does not work. SQL Server is not, and has never been, up-level compatible.

Is a copy of the database still attached to a SQL Server 2005 instance somewhere too? What have you done to try to recover it?

Paul Randal
Principal Lead Program Manager, Microsoft SQL Server Core Storage Engine
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)
http://blogs.msdn.com/sqlserverstorageengine/default.aspx

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources