I have come across an issue trying to restore a backup of my SQL7 to SQL2000. I migrated to SBS2003 and have restored our database to SQL 2000 many times for testing. Durning my final migration is when I started encountering this error when I execute:
restore database fisc
from disk = 'C:\JEP\fiscbackup
with recovery,
move 'fisc_Data' to 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\fisc_Data.MDF',
move 'fisc_Log' to 'C:\Program Files\Microsoft SQL Ser4ver\MSSQL\Data\fisc_Log.MDF'
The script has worked before but is now returning error:
Server: Msg 3101, Level 16, State 1, Line 1
Exclusive access could not be obtained because the database is in use.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
I have run sp_who and it shows 17 loginname entries of sa with a status of either sleeping or background. SPID 51 shows administrator with a status of runnable. I have tried using kill but it will not kill the administrator since that is the login I am
using to run the script.
Any ideas of what I can do to get the database to restore?
Thanks,
Jason Pintok
Hi,
Execute the below script from master to restore the FISC database (Execute
all the lines in a together from query analyzer)
use master
go
alter database fisc set single_user with rollback immediate
go
restore database fisc
from disk = 'C:\JEP\fiscbackup
with recovery,
move 'fisc_Data' to 'C:\Program Files\Microsoft SQL
Server\MSSQL\Data\fisc_Data.MDF',
move 'fisc_Log' to 'C:\Program Files\Microsoft SQL
Ser4ver\MSSQL\Data\fisc_Log.MDF'
Thanks
Hari
MCDBA
"Jason Pintok" <anonymous@.discussions.microsoft.com> wrote in message
news:7301F6E9-1E57-4B94-9591-6C984B05D6ED@.microsoft.com...
> I have come across an issue trying to restore a backup of my SQL7 to
SQL2000. I migrated to SBS2003 and have restored our database to SQL 2000
many times for testing. Durning my final migration is when I started
encountering this error when I execute:
> restore database fisc
> from disk = 'C:\JEP\fiscbackup
> with recovery,
> move 'fisc_Data' to 'C:\Program Files\Microsoft SQL
Server\MSSQL\Data\fisc_Data.MDF',
> move 'fisc_Log' to 'C:\Program Files\Microsoft SQL
Ser4ver\MSSQL\Data\fisc_Log.MDF'
> The script has worked before but is now returning error:
> Server: Msg 3101, Level 16, State 1, Line 1
> Exclusive access could not be obtained because the database is in use.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
> I have run sp_who and it shows 17 loginname entries of sa with a status of
either sleeping or background. SPID 51 shows administrator with a status of
runnable. I have tried using kill but it will not kill the administrator
since that is the login I am using to run the script.
> Any ideas of what I can do to get the database to restore?
> Thanks,
> Jason Pintok
|||Thanks Hari, that nailed it. I appreciate the help.
Jason Pintok
Showing posts with label sql7. Show all posts
Showing posts with label sql7. Show all posts
Friday, March 23, 2012
Restore Terminating
I have come across an issue trying to restore a backup of my SQL7 to SQL2000
. I migrated to SBS2003 and have restored our database to SQL 2000 many ti
mes for testing. Durning my final migration is when I started encountering
this error when I execute:
restore database fisc
from disk = 'C:\JEP\fiscbackup
with recovery,
move 'fisc_Data' to 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\fisc_D
ata.MDF',
move 'fisc_Log' to 'C:\Program Files\Microsoft SQL Ser4ver\MSSQL\Data\fisc_L
og.MDF'
The script has worked before but is now returning error:
Server: Msg 3101, Level 16, State 1, Line 1
Exclusive access could not be obtained because the database is in use.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
I have run sp_who and it shows 17 loginname entries of sa with a status of e
ither sleeping or background. SPID 51 shows administrator with a status of
runnable. I have tried using kill but it will not kill the administrator si
nce that is the login I am
using to run the script.
Any ideas of what I can do to get the database to restore?
Thanks,
Jason PintokHi,
Execute the below script from master to restore the FISC database (Execute
all the lines in a together from query analyzer)
use master
go
alter database fisc set single_user with rollback immediate
go
restore database fisc
from disk = 'C:\JEP\fiscbackup
with recovery,
move 'fisc_Data' to 'C:\Program Files\Microsoft SQL
Server\MSSQL\Data\fisc_Data.MDF',
move 'fisc_Log' to 'C:\Program Files\Microsoft SQL
Ser4ver\MSSQL\Data\fisc_Log.MDF'
Thanks
Hari
MCDBA
"Jason Pintok" <anonymous@.discussions.microsoft.com> wrote in message
news:7301F6E9-1E57-4B94-9591-6C984B05D6ED@.microsoft.com...
> I have come across an issue trying to restore a backup of my SQL7 to
SQL2000. I migrated to SBS2003 and have restored our database to SQL 2000
many times for testing. Durning my final migration is when I started
encountering this error when I execute:
> restore database fisc
> from disk = 'C:\JEP\fiscbackup
> with recovery,
> move 'fisc_Data' to 'C:\Program Files\Microsoft SQL
Server\MSSQL\Data\fisc_Data.MDF',
> move 'fisc_Log' to 'C:\Program Files\Microsoft SQL
Ser4ver\MSSQL\Data\fisc_Log.MDF'
> The script has worked before but is now returning error:
> Server: Msg 3101, Level 16, State 1, Line 1
> Exclusive access could not be obtained because the database is in use.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
> I have run sp_who and it shows 17 loginname entries of sa with a status of
either sleeping or background. SPID 51 shows administrator with a status of
runnable. I have tried using kill but it will not kill the administrator
since that is the login I am using to run the script.
> Any ideas of what I can do to get the database to restore?
> Thanks,
> Jason Pintok|||Thanks Hari, that nailed it. I appreciate the help.
Jason Pintok
. I migrated to SBS2003 and have restored our database to SQL 2000 many ti
mes for testing. Durning my final migration is when I started encountering
this error when I execute:
restore database fisc
from disk = 'C:\JEP\fiscbackup
with recovery,
move 'fisc_Data' to 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\fisc_D
ata.MDF',
move 'fisc_Log' to 'C:\Program Files\Microsoft SQL Ser4ver\MSSQL\Data\fisc_L
og.MDF'
The script has worked before but is now returning error:
Server: Msg 3101, Level 16, State 1, Line 1
Exclusive access could not be obtained because the database is in use.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
I have run sp_who and it shows 17 loginname entries of sa with a status of e
ither sleeping or background. SPID 51 shows administrator with a status of
runnable. I have tried using kill but it will not kill the administrator si
nce that is the login I am
using to run the script.
Any ideas of what I can do to get the database to restore?
Thanks,
Jason PintokHi,
Execute the below script from master to restore the FISC database (Execute
all the lines in a together from query analyzer)
use master
go
alter database fisc set single_user with rollback immediate
go
restore database fisc
from disk = 'C:\JEP\fiscbackup
with recovery,
move 'fisc_Data' to 'C:\Program Files\Microsoft SQL
Server\MSSQL\Data\fisc_Data.MDF',
move 'fisc_Log' to 'C:\Program Files\Microsoft SQL
Ser4ver\MSSQL\Data\fisc_Log.MDF'
Thanks
Hari
MCDBA
"Jason Pintok" <anonymous@.discussions.microsoft.com> wrote in message
news:7301F6E9-1E57-4B94-9591-6C984B05D6ED@.microsoft.com...
> I have come across an issue trying to restore a backup of my SQL7 to
SQL2000. I migrated to SBS2003 and have restored our database to SQL 2000
many times for testing. Durning my final migration is when I started
encountering this error when I execute:
> restore database fisc
> from disk = 'C:\JEP\fiscbackup
> with recovery,
> move 'fisc_Data' to 'C:\Program Files\Microsoft SQL
Server\MSSQL\Data\fisc_Data.MDF',
> move 'fisc_Log' to 'C:\Program Files\Microsoft SQL
Ser4ver\MSSQL\Data\fisc_Log.MDF'
> The script has worked before but is now returning error:
> Server: Msg 3101, Level 16, State 1, Line 1
> Exclusive access could not be obtained because the database is in use.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
> I have run sp_who and it shows 17 loginname entries of sa with a status of
either sleeping or background. SPID 51 shows administrator with a status of
runnable. I have tried using kill but it will not kill the administrator
since that is the login I am using to run the script.
> Any ideas of what I can do to get the database to restore?
> Thanks,
> Jason Pintok|||Thanks Hari, that nailed it. I appreciate the help.
Jason Pintok
Wednesday, March 7, 2012
Restore MSSQL7 Backup data to MSSQL2000
Dear all,
I want to transfer data from SQL7 to SQL2000, so I backup the data and
restore it in SQL2000. But it fails to do so due to different version. Do
everyone know how to do this? Thanks
Rdgs
Ellis
Hi,
Did you tried to restore a SYSTEM database ? System database can not be
restored from SQL 7 to SQL 2000. How ever all the
user databases can be backed up from SQL 7 and can be restored to SQL 2000
with out any issues. During the restore itself it
does a version conversion. But execute the procedure "SP_UPDATESTATS" after
the restoration to get the optimal performance.
Note:
FYI, You can not restor a SQL 2000 database backup to SQL 7. Only option to
copy the data is use DTS.
Thanks
Hari
MCDBA
"Ellis Yu" <ellis.yu@.transfield.com> wrote in message
news:eLIJgImhEHA.3140@.TK2MSFTNGP10.phx.gbl...
> Dear all,
> I want to transfer data from SQL7 to SQL2000, so I backup the data and
> restore it in SQL2000. But it fails to do so due to different version. Do
> everyone know how to do this? Thanks
> Rdgs
> Ellis
>
|||Thanks a lot !!! It's very useful
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:#JxmhPmhEHA.3476@.tk2msftngp13.phx.gbl...
> Hi,
> Did you tried to restore a SYSTEM database ? System database can not be
> restored from SQL 7 to SQL 2000. How ever all the
> user databases can be backed up from SQL 7 and can be restored to SQL 2000
> with out any issues. During the restore itself it
> does a version conversion. But execute the procedure "SP_UPDATESTATS"
after
> the restoration to get the optimal performance.
>
> Note:
> FYI, You can not restor a SQL 2000 database backup to SQL 7. Only option
to[vbcol=seagreen]
> copy the data is use DTS.
> Thanks
> Hari
> MCDBA
> "Ellis Yu" <ellis.yu@.transfield.com> wrote in message
> news:eLIJgImhEHA.3140@.TK2MSFTNGP10.phx.gbl...
and[vbcol=seagreen]
Do
>
I want to transfer data from SQL7 to SQL2000, so I backup the data and
restore it in SQL2000. But it fails to do so due to different version. Do
everyone know how to do this? Thanks
Rdgs
Ellis
Hi,
Did you tried to restore a SYSTEM database ? System database can not be
restored from SQL 7 to SQL 2000. How ever all the
user databases can be backed up from SQL 7 and can be restored to SQL 2000
with out any issues. During the restore itself it
does a version conversion. But execute the procedure "SP_UPDATESTATS" after
the restoration to get the optimal performance.
Note:
FYI, You can not restor a SQL 2000 database backup to SQL 7. Only option to
copy the data is use DTS.
Thanks
Hari
MCDBA
"Ellis Yu" <ellis.yu@.transfield.com> wrote in message
news:eLIJgImhEHA.3140@.TK2MSFTNGP10.phx.gbl...
> Dear all,
> I want to transfer data from SQL7 to SQL2000, so I backup the data and
> restore it in SQL2000. But it fails to do so due to different version. Do
> everyone know how to do this? Thanks
> Rdgs
> Ellis
>
|||Thanks a lot !!! It's very useful
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:#JxmhPmhEHA.3476@.tk2msftngp13.phx.gbl...
> Hi,
> Did you tried to restore a SYSTEM database ? System database can not be
> restored from SQL 7 to SQL 2000. How ever all the
> user databases can be backed up from SQL 7 and can be restored to SQL 2000
> with out any issues. During the restore itself it
> does a version conversion. But execute the procedure "SP_UPDATESTATS"
after
> the restoration to get the optimal performance.
>
> Note:
> FYI, You can not restor a SQL 2000 database backup to SQL 7. Only option
to[vbcol=seagreen]
> copy the data is use DTS.
> Thanks
> Hari
> MCDBA
> "Ellis Yu" <ellis.yu@.transfield.com> wrote in message
> news:eLIJgImhEHA.3140@.TK2MSFTNGP10.phx.gbl...
and[vbcol=seagreen]
Do
>
Restore MSSQL7 Backup data to MSSQL2000
Dear all,
I want to transfer data from SQL7 to SQL2000, so I backup the data and
restore it in SQL2000. But it fails to do so due to different version. Do
everyone know how to do this' Thanks
Rdgs
EllisHi,
Did you tried to restore a SYSTEM database ? System database can not be
restored from SQL 7 to SQL 2000. How ever all the
user databases can be backed up from SQL 7 and can be restored to SQL 2000
with out any issues. During the restore itself it
does a version conversion. But execute the procedure "SP_UPDATESTATS" after
the restoration to get the optimal performance.
Note:
FYI, You can not restor a SQL 2000 database backup to SQL 7. Only option to
copy the data is use DTS.
Thanks
Hari
MCDBA
"Ellis Yu" <ellis.yu@.transfield.com> wrote in message
news:eLIJgImhEHA.3140@.TK2MSFTNGP10.phx.gbl...
> Dear all,
> I want to transfer data from SQL7 to SQL2000, so I backup the data and
> restore it in SQL2000. But it fails to do so due to different version. Do
> everyone know how to do this' Thanks
> Rdgs
> Ellis
>|||Thanks a lot !!! It's very useful
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:#JxmhPmhEHA.3476@.tk2msftngp13.phx.gbl...
> Hi,
> Did you tried to restore a SYSTEM database ? System database can not be
> restored from SQL 7 to SQL 2000. How ever all the
> user databases can be backed up from SQL 7 and can be restored to SQL 2000
> with out any issues. During the restore itself it
> does a version conversion. But execute the procedure "SP_UPDATESTATS"
after
> the restoration to get the optimal performance.
>
> Note:
> FYI, You can not restor a SQL 2000 database backup to SQL 7. Only option
to
> copy the data is use DTS.
> Thanks
> Hari
> MCDBA
> "Ellis Yu" <ellis.yu@.transfield.com> wrote in message
> news:eLIJgImhEHA.3140@.TK2MSFTNGP10.phx.gbl...
> > Dear all,
> > I want to transfer data from SQL7 to SQL2000, so I backup the data
and
> > restore it in SQL2000. But it fails to do so due to different version.
Do
> > everyone know how to do this' Thanks
> >
> > Rdgs
> > Ellis
> >
> >
>
I want to transfer data from SQL7 to SQL2000, so I backup the data and
restore it in SQL2000. But it fails to do so due to different version. Do
everyone know how to do this' Thanks
Rdgs
EllisHi,
Did you tried to restore a SYSTEM database ? System database can not be
restored from SQL 7 to SQL 2000. How ever all the
user databases can be backed up from SQL 7 and can be restored to SQL 2000
with out any issues. During the restore itself it
does a version conversion. But execute the procedure "SP_UPDATESTATS" after
the restoration to get the optimal performance.
Note:
FYI, You can not restor a SQL 2000 database backup to SQL 7. Only option to
copy the data is use DTS.
Thanks
Hari
MCDBA
"Ellis Yu" <ellis.yu@.transfield.com> wrote in message
news:eLIJgImhEHA.3140@.TK2MSFTNGP10.phx.gbl...
> Dear all,
> I want to transfer data from SQL7 to SQL2000, so I backup the data and
> restore it in SQL2000. But it fails to do so due to different version. Do
> everyone know how to do this' Thanks
> Rdgs
> Ellis
>|||Thanks a lot !!! It's very useful
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:#JxmhPmhEHA.3476@.tk2msftngp13.phx.gbl...
> Hi,
> Did you tried to restore a SYSTEM database ? System database can not be
> restored from SQL 7 to SQL 2000. How ever all the
> user databases can be backed up from SQL 7 and can be restored to SQL 2000
> with out any issues. During the restore itself it
> does a version conversion. But execute the procedure "SP_UPDATESTATS"
after
> the restoration to get the optimal performance.
>
> Note:
> FYI, You can not restor a SQL 2000 database backup to SQL 7. Only option
to
> copy the data is use DTS.
> Thanks
> Hari
> MCDBA
> "Ellis Yu" <ellis.yu@.transfield.com> wrote in message
> news:eLIJgImhEHA.3140@.TK2MSFTNGP10.phx.gbl...
> > Dear all,
> > I want to transfer data from SQL7 to SQL2000, so I backup the data
and
> > restore it in SQL2000. But it fails to do so due to different version.
Do
> > everyone know how to do this' Thanks
> >
> > Rdgs
> > Ellis
> >
> >
>
Restore MSSQL7 Backup data to MSSQL2000
Dear all,
I want to transfer data from SQL7 to SQL2000, so I backup the data and
restore it in SQL2000. But it fails to do so due to different version. Do
everyone know how to do this' Thanks
Rdgs
EllisHi,
Did you tried to restore a SYSTEM database ? System database can not be
restored from SQL 7 to SQL 2000. How ever all the
user databases can be backed up from SQL 7 and can be restored to SQL 2000
with out any issues. During the restore itself it
does a version conversion. But execute the procedure "SP_UPDATESTATS" after
the restoration to get the optimal performance.
Note:
FYI, You can not restor a SQL 2000 database backup to SQL 7. Only option to
copy the data is use DTS.
Thanks
Hari
MCDBA
"Ellis Yu" <ellis.yu@.transfield.com> wrote in message
news:eLIJgImhEHA.3140@.TK2MSFTNGP10.phx.gbl...
> Dear all,
> I want to transfer data from SQL7 to SQL2000, so I backup the data and
> restore it in SQL2000. But it fails to do so due to different version. Do
> everyone know how to do this' Thanks
> Rdgs
> Ellis
>|||Thanks a lot !!! It's very useful
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:#JxmhPmhEHA.3476@.tk2msftngp13.phx.gbl...
> Hi,
> Did you tried to restore a SYSTEM database ? System database can not be
> restored from SQL 7 to SQL 2000. How ever all the
> user databases can be backed up from SQL 7 and can be restored to SQL 2000
> with out any issues. During the restore itself it
> does a version conversion. But execute the procedure "SP_UPDATESTATS"
after
> the restoration to get the optimal performance.
>
> Note:
> FYI, You can not restor a SQL 2000 database backup to SQL 7. Only option
to
> copy the data is use DTS.
> Thanks
> Hari
> MCDBA
> "Ellis Yu" <ellis.yu@.transfield.com> wrote in message
> news:eLIJgImhEHA.3140@.TK2MSFTNGP10.phx.gbl...
and[vbcol=seagreen]
Do[vbcol=seagreen]
>
I want to transfer data from SQL7 to SQL2000, so I backup the data and
restore it in SQL2000. But it fails to do so due to different version. Do
everyone know how to do this' Thanks
Rdgs
EllisHi,
Did you tried to restore a SYSTEM database ? System database can not be
restored from SQL 7 to SQL 2000. How ever all the
user databases can be backed up from SQL 7 and can be restored to SQL 2000
with out any issues. During the restore itself it
does a version conversion. But execute the procedure "SP_UPDATESTATS" after
the restoration to get the optimal performance.
Note:
FYI, You can not restor a SQL 2000 database backup to SQL 7. Only option to
copy the data is use DTS.
Thanks
Hari
MCDBA
"Ellis Yu" <ellis.yu@.transfield.com> wrote in message
news:eLIJgImhEHA.3140@.TK2MSFTNGP10.phx.gbl...
> Dear all,
> I want to transfer data from SQL7 to SQL2000, so I backup the data and
> restore it in SQL2000. But it fails to do so due to different version. Do
> everyone know how to do this' Thanks
> Rdgs
> Ellis
>|||Thanks a lot !!! It's very useful
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:#JxmhPmhEHA.3476@.tk2msftngp13.phx.gbl...
> Hi,
> Did you tried to restore a SYSTEM database ? System database can not be
> restored from SQL 7 to SQL 2000. How ever all the
> user databases can be backed up from SQL 7 and can be restored to SQL 2000
> with out any issues. During the restore itself it
> does a version conversion. But execute the procedure "SP_UPDATESTATS"
after
> the restoration to get the optimal performance.
>
> Note:
> FYI, You can not restor a SQL 2000 database backup to SQL 7. Only option
to
> copy the data is use DTS.
> Thanks
> Hari
> MCDBA
> "Ellis Yu" <ellis.yu@.transfield.com> wrote in message
> news:eLIJgImhEHA.3140@.TK2MSFTNGP10.phx.gbl...
and[vbcol=seagreen]
Do[vbcol=seagreen]
>
Monday, February 20, 2012
Restore master database with upgrade from SQL7 to SQL2000
Dear all,
I would like to copy all DB's (incl. master) from a machine running SQL7 to another machine running SQL2000.
I was thinking about a backup/restore method, but I have a problem with 'master'. I get this error message:
The backup of the system database on device T:\BACKUPS\DataBkp\MASTERBKP cannot be restored because it was created by a different version of the server (117441473) than this server (134218112).
How can I upgrade my backup file so that SQL2000 can read it?
Thanks in advance.If I understand you want to port you SQL Server 7.0 environment to a SQL Server 2000 environment and retain your SQL Server 7.0 environment as well.
This may be the long way but how about the following steps:
1) Install SQL Server 7.0 (A) on the soon to be SQL Server 2000 first.
2) Move the databases from the original SQL Server 7 (B) over
3) Upgrade SQL Server 7.0 (A) to 2000|||Right!
It seems to be the only solution. And I would have had the same problem with msdb and model (see http://support.microsoft.com/default.aspx?scid=kb;en-us;Q264474)
Thanks for your help!
--marc
I would like to copy all DB's (incl. master) from a machine running SQL7 to another machine running SQL2000.
I was thinking about a backup/restore method, but I have a problem with 'master'. I get this error message:
The backup of the system database on device T:\BACKUPS\DataBkp\MASTERBKP cannot be restored because it was created by a different version of the server (117441473) than this server (134218112).
How can I upgrade my backup file so that SQL2000 can read it?
Thanks in advance.If I understand you want to port you SQL Server 7.0 environment to a SQL Server 2000 environment and retain your SQL Server 7.0 environment as well.
This may be the long way but how about the following steps:
1) Install SQL Server 7.0 (A) on the soon to be SQL Server 2000 first.
2) Move the databases from the original SQL Server 7 (B) over
3) Upgrade SQL Server 7.0 (A) to 2000|||Right!
It seems to be the only solution. And I would have had the same problem with msdb and model (see http://support.microsoft.com/default.aspx?scid=kb;en-us;Q264474)
Thanks for your help!
--marc
Subscribe to:
Posts (Atom)