need server 2005 or 2008 - SQL Server Forums

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

New to SQL Server Programming

need server 2005 or 2008

Author

Topic

pascal_jimi
Posting Yak Master

167 Posts

Posted - 2015-01-13 : 07:36:20

hi all my friends

I have a problem

my old server to work sql2000

but now was give sql2012

I made a backup and want to open in 2012 sql server

but just sql 2000 bak file in 2012 give me a error

I do not have a 2005 or 2008

and what I can do an
what advice eats?

and who can then open and attach a new backup here in 2005 or 2008

to the article in the eating login
UTB can something meshat during Recovery Tools?

Link file in google + -------- https://drive.google.com/file/d/0B1xDKe0aB-MqejNabjV1aDdDZ00/view?usp=sharing
Thank you very much

http://sql-az.tr.gg/

Ifor
Aged Yak Warrior

700 Posts

Posted - 2015-01-13 : 07:53:11

I think SQL2008R2 is the latest version that will open a SQL2000 backup, so:

1. Download SQL2008R2 Express and install it.
2. Restore SQL2000 backup to SQL2008R2 Express.
3. Backup the DB from SQL2008R2 Express.
4. Restore the SQL2008R2 Express backup into SQL2012.

An alternative would be to:
1. script the DB from SQL2000
2. apply the the script to SQL2012
3. from SQL2012, import the data from SQL2000

pascal_jimi
Posting Yak Master

167 Posts

Posted - 2015-01-13 : 08:10:50

thanks
but how can i give all scripts db 2000?

http://sql-az.tr.gg/

pascal_jimi
Posting Yak Master

167 Posts

Posted - 2015-01-15 : 01:54:35

friends

1 --- I discovered this beautiful bey on sql server 2008 r2
2 --- again made a new backup
3 --- and recorded skprit on sql 2012

use master
go
RESTORE DATABASE [new] FROM DISK = N'C: \ Program Files \ Microsoft SQL Server \ MSSQL11.MSSQLSERVER \ MSSQL \ Backup \ 15yanvar.bak 'WITH FILE = 1,
MOVE N'ats342 'TO N'C: \ Program Files \ Microsoft SQL Server \ MSSQL11.MSSQLSERVER \ MSSQL \ DATA \ ats342.mdf', MOVE N'ats342_log '
TO N'C: \ Program Files \ Microsoft SQL Server \ MSSQL11.MSSQLSERVER \ MSSQL \ DATA \ ats342_log.ldf ', NOUNLOAD, REPLACE, STATS = 10
go

and also get the error

Msg 3169, Level 16, State 1, Line 1
The database was backed up on a server running version 8.00.2039. That version is incompatible with this server, which is running version 11.00.2100. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

http://sql-az.tr.gg/

pascal_jimi
Posting Yak Master

167 Posts

Posted - 2015-01-15 : 02:36:49

I know 8.00.2039 ---version it is sql 2000 but no 2008
but now was new backup from sql server 2008 r2
and was liked open in sql 2012

was use this script

use master
go
RESTORE DATABASE [new] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\yenibacup.bak' WITH FILE = 1,
MOVE N'ats342' TO N'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\ats342.mdf', MOVE N'ats342_log '
TO N'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\ats342_log.ldf', NOUNLOAD, REPLACE, STATS = 10
go

but now give me a error message

Msg 1834, Level 16, State 1, Line 1
The file 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\ats342.mdf' cannot be overwritten. It is being used by database 'ats342'.
Msg 3156, Level 16, State 4, Line 1
File 'ats342' cannot be restored to 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\ats342.mdf'. Use WITH MOVE to identify a valid location for the file.
Msg 1834, Level 16, State 1, Line 1
The file 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\ats342_log.ldf' cannot be overwritten. It is being used by database 'ats342'.
Msg 3156, Level 16, State 4, Line 1
File 'ats342_log' cannot be restored to 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\ats342_log.ldf'. Use WITH MOVE to identify a valid location for the file.
Msg 3119, Level 16, State 1, Line 1
Problems were identified while planning for the RESTORE statement. Previous messages provide details.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally

http://sql-az.tr.gg/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources