Error al Abrir BD Generada en SQL2005Developers

20/04/2006 - 19:47 por Developers - Dany Acosta | Informe spam
Amigos estoy tratanto de atachar una base de datos que tengo en sql2005
developers hacia sql2005 Express con este comando:

USE [master]
GO
CREATE DATABASE [C:\Documents and Settings\User
1\Desktop\AsynchronousExample\Asynchronous\Asynchronous\Databases\Data.mdf]
ON
( FILENAME = N'D:\desarrollo\Vs.Net\2005\101 Samples (VB)\Data
Access\Asynchronous Queries\Asynchronous\Databases\Data.mdf' ),
( FILENAME = N'D:\desarrollo\Vs.Net\2005\101 Samples (VB)\Data
Access\Asynchronous Queries\Asynchronous\Databases\Data_log.LDF' )
FOR ATTACH
GO
if not exists (select name from master.sys.databases sd where name =
N'C:\Documents and Settings\User
1\Desktop\AsynchronousExample\Asynchronous\Asynchronous\Databases\Data.mdf'
and SUSER_SNAME(sd.owner_sid) = SUSER_SNAME() ) EXEC [C:\Documents and
Settings\User
1\Desktop\AsynchronousExample\Asynchronous\Asynchronous\Databases\Data.mdf].dbo.sp_changedbowner
@loginame=N'sa', @map=false
GO

Pero me muestra este mensaje de Error:

Msg 1813, Level 16, State 2, Line 1
Could not open new database 'C:\Documents and Settings\User
1\Desktop\AsynchronousExample\Asynchronous\Asynchronous\Databases\Data.mdf'.
CREATE DATABASE is aborted.
Msg 950, Level 20, State 1, Line 1
Database 'C:\Documents and Settings\User
1\Desktop\AsynchronousExample\Asynchronous\Asynchronous\Databases\Data.mdf'
cannot be upgraded because its non-release version (600) is not
supported by this version of SQL Server. You cannot open a database that
is incompatible with this version of sqlservr.exe. You must re-create
the database.

Como puedo hacer para solucionar este tipo de Error


Gracias

Developers - Dany Acosta
 

Leer las respuestas

#1 Maxi
20/04/2006 - 22:51 | Informe spam
Hola, cuanto pesa esa bdd?


Salu2
Maxi [MVP SQL SERVER]
www.sqlgurus.org


"Developers - Dany Acosta" escribió en el mensaje
news:
Amigos estoy tratanto de atachar una base de datos que tengo en sql2005
developers hacia sql2005 Express con este comando:

USE [master]
GO
CREATE DATABASE [C:\Documents and Settings\User
1\Desktop\AsynchronousExample\Asynchronous\Asynchronous\Databases\Data.mdf]
ON
( FILENAME = N'D:\desarrollo\Vs.Net\2005\101 Samples (VB)\Data
Access\Asynchronous Queries\Asynchronous\Databases\Data.mdf' ),
( FILENAME = N'D:\desarrollo\Vs.Net\2005\101 Samples (VB)\Data
Access\Asynchronous Queries\Asynchronous\Databases\Data_log.LDF' )
FOR ATTACH
GO
if not exists (select name from master.sys.databases sd where name =
N'C:\Documents and Settings\User
1\Desktop\AsynchronousExample\Asynchronous\Asynchronous\Databases\Data.mdf'
and SUSER_SNAME(sd.owner_sid) = SUSER_SNAME() ) EXEC [C:\Documents and
Settings\User
1\Desktop\AsynchronousExample\Asynchronous\Asynchronous\Databases\Data.mdf].dbo.sp_changedbowner
@loginame=N'sa', @map=false
GO

Pero me muestra este mensaje de Error:

Msg 1813, Level 16, State 2, Line 1
Could not open new database 'C:\Documents and Settings\User
1\Desktop\AsynchronousExample\Asynchronous\Asynchronous\Databases\Data.mdf'.
CREATE DATABASE is aborted.
Msg 950, Level 20, State 1, Line 1
Database 'C:\Documents and Settings\User
1\Desktop\AsynchronousExample\Asynchronous\Asynchronous\Databases\Data.mdf'
cannot be upgraded because its non-release version (600) is not supported
by this version of SQL Server. You cannot open a database that is
incompatible with this version of sqlservr.exe. You must re-create the
database.

Como puedo hacer para solucionar este tipo de Error


Gracias

Developers - Dany Acosta

Preguntas similares