|
Home > Archive > microsoft.public.sqlserver.server > October 2002 > Error duing backup from Query Analyzer
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Error duing backup from Query Analyzer
|
|
|
| I wanted to take a backup of the Sql Server 2000 database
and restore in Sql Server 7.
I changed the db compatability level to 7 by executing the
stored procedure
sp_dbcmptlevel 'slxtest03', 70
success.
Now when I try to run the backup command - I get the
following errors.
Server: Msg 3201, Level 16, State 1, Line 1
Cannot open backup device 'd:\temp\backuptest01.bak'.
Device error or device off-line. See the SQL Server error
log for more details.
Server: Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.
Backup command - I used is as following
BACKUP DATABASE slxtest03 TO DISK
= 'd:\temp\backuptest01.bak'
Please let me know, if any knows the answers. I donot find
documentation for 3201 error.
Thank you
| |
| Jasper Smith 2002-10-31, 6:23 pm |
| Regardless of the compatability level of the database,
you cannot restore a SQL 2000 database to SQL7,
their on disk structures are different.You can use DTS
or bcp to move the data back to SQL7.
--
HTH
Jasper Smith (SQL Server MVP)
Check out the PASS Community Summit - Seattle, the largest and only user
event entirely dedicated to SQL Server, November 19-22.
http://www.sqlpass.org/events/seattle/index.cfm
"sri" <kusrinivas@yahoo.com> wrote in message
news:8a8a01c28134$4bab8690$3be
f2ecf@TKMSFTNGXA10...
> I wanted to take a backup of the Sql Server 2000 database
> and restore in Sql Server 7.
>
> I changed the db compatability level to 7 by executing the
> stored procedure
>
> sp_dbcmptlevel 'slxtest03', 70
>
> success.
>
> Now when I try to run the backup command - I get the
> following errors.
>
> Server: Msg 3201, Level 16, State 1, Line 1
> Cannot open backup device 'd:\temp\backuptest01.bak'.
> Device error or device off-line. See the SQL Server error
> log for more details.
> Server: Msg 3013, Level 16, State 1, Line 1
> BACKUP DATABASE is terminating abnormally.
>
> Backup command - I used is as following
>
> BACKUP DATABASE slxtest03 TO DISK
> = 'd:\temp\backuptest01.bak'
>
> Please let me know, if any knows the answers. I donot find
> documentation for 3201 error.
>
> Thank you
|
|
|
|
|