Restoring SQL Server 6.5 .DAT file to SQL 2000

All,
My client has give me a 6.5 backup file in a .DAT format.
I want to restore it in SQL2000.
"Amit" <Amit@.discussions.microsoft.com> wrote in message
news:E15A0D61-F208-4FC8-B7A4-53A7461B24EA@.microsoft.com...
> All,
> My client has give me a 6.5 backup file in a .DAT format.
> I want to restore it in SQL2000.
>
You cannot restore it to SQL 2k.
You can only restore it (painfully) to a 6.5 system and then perform
upgrades on it.
Rick Sawtell
MCT, MCSD, MCDBA
|||No can do. You will have to build a SQL 6.5 server, restore the file, then
convert to 7.0/2000. Without the sysdevices, sysdatabases, and sysusages
information, you cannot restore a SQL 6.5 database. Unlike SQL 7.0 and
higher, SQL 6.5 database backups are not self-describing.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Amit" <Amit@.discussions.microsoft.com> wrote in message
news:E15A0D61-F208-4FC8-B7A4-53A7461B24EA@.microsoft.com...
> All,
> My client has give me a 6.5 backup file in a .DAT format.
> I want to restore it in SQL2000.
>
|||Hi,
SQL 6.5 and SQL 2000 architecture is different and since the backup restore
is not allowed. So only possibility is:-
1. Restore the 6.5 backup DAT file into SQL 6.5 machine
2. INstall SQL 2000 and service pack
3. Use Upgrade wizard rto upgrade the SQL 6.5 database to SQL 2000
4. Upgrade wizard will copy all the data / objects to SQL 2000.
Note:-
Execute a DBCC and update statistics before the upgrade
Thanks
Hari
SQL Server MVP
"Amit" <Amit@.discussions.microsoft.com> wrote in message
news:E15A0D61-F208-4FC8-B7A4-53A7461B24EA@.microsoft.com...
> All,
> My client has give me a 6.5 backup file in a .DAT format.
> I want to restore it in SQL2000.
>
|||In addition to the other posts:
You *might* be able to restore your 6.5 backup on another 6.5 machine even if you don't know the
database fragments (master..sysusages etc). But you will end up with data pages where SQL Server
expects log pages and vice versa. For data pages where SQL Server expects log pages, DBCC NEWALLOG
will return 2558 errors (I believe) and you have to physically move the data. Possibly create script
and transfer all over to a new database. Possibly by rebuilding all indexes. Not to be taken lightly
if you don't have good 6.5 expertise.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Amit" <Amit@.discussions.microsoft.com> wrote in message
news:E15A0D61-F208-4FC8-B7A4-53A7461B24EA@.microsoft.com...
> All,
> My client has give me a 6.5 backup file in a .DAT format.
> I want to restore it in SQL2000.
>
|||Thanks every one for taking time to reply :-)
Regards
Amit
"Amit" wrote:

> All,
> My client has give me a 6.5 backup file in a .DAT format.
> I want to restore it in SQL2000.
>

Restoring SQL Server 6.5 .DAT file to SQL 2000

All,
My client has give me a 6.5 backup file in a .DAT format.
I want to restore it in SQL2000."Amit" <Amit@.discussions.microsoft.com> wrote in message
news:E15A0D61-F208-4FC8-B7A4-53A7461B24EA@.microsoft.com...
> All,
> My client has give me a 6.5 backup file in a .DAT format.
> I want to restore it in SQL2000.
>
You cannot restore it to SQL 2k.
You can only restore it (painfully) to a 6.5 system and then perform
upgrades on it.
Rick Sawtell
MCT, MCSD, MCDBA|||No can do. You will have to build a SQL 6.5 server, restore the file, then
convert to 7.0/2000. Without the sysdevices, sysdatabases, and sysusages
information, you cannot restore a SQL 6.5 database. Unlike SQL 7.0 and
higher, SQL 6.5 database backups are not self-describing.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Amit" <Amit@.discussions.microsoft.com> wrote in message
news:E15A0D61-F208-4FC8-B7A4-53A7461B24EA@.microsoft.com...
> All,
> My client has give me a 6.5 backup file in a .DAT format.
> I want to restore it in SQL2000.
>|||Hi,
SQL 6.5 and SQL 2000 architecture is different and since the backup restore
is not allowed. So only possibility is:-
1. Restore the 6.5 backup DAT file into SQL 6.5 machine
2. INstall SQL 2000 and service pack
3. Use Upgrade wizard rto upgrade the SQL 6.5 database to SQL 2000
4. Upgrade wizard will copy all the data / objects to SQL 2000.
Note:-
Execute a DBCC and update statistics before the upgrade
Thanks
Hari
SQL Server MVP
"Amit" <Amit@.discussions.microsoft.com> wrote in message
news:E15A0D61-F208-4FC8-B7A4-53A7461B24EA@.microsoft.com...
> All,
> My client has give me a 6.5 backup file in a .DAT format.
> I want to restore it in SQL2000.
>|||In addition to the other posts:
You *might* be able to restore your 6.5 backup on another 6.5 machine even if you don't know the
database fragments (master..sysusages etc). But you will end up with data pages where SQL Server
expects log pages and vice versa. For data pages where SQL Server expects log pages, DBCC NEWALLOG
will return 2558 errors (I believe) and you have to physically move the data. Possibly create script
and transfer all over to a new database. Possibly by rebuilding all indexes. Not to be taken lightly
if you don't have good 6.5 expertise.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Amit" <Amit@.discussions.microsoft.com> wrote in message
news:E15A0D61-F208-4FC8-B7A4-53A7461B24EA@.microsoft.com...
> All,
> My client has give me a 6.5 backup file in a .DAT format.
> I want to restore it in SQL2000.
>|||Thanks every one for taking time to reply :-)
Regards
Amit
"Amit" wrote:
> All,
> My client has give me a 6.5 backup file in a .DAT format.
> I want to restore it in SQL2000.
>

Restoring SQL Server 6.5 .DAT file to SQL 2000

All,
My client has give me a 6.5 backup file in a .DAT format.
I want to restore it in SQL2000."Amit" <Amit@.discussions.microsoft.com> wrote in message
news:E15A0D61-F208-4FC8-B7A4-53A7461B24EA@.microsoft.com...
> All,
> My client has give me a 6.5 backup file in a .DAT format.
> I want to restore it in SQL2000.
>
You cannot restore it to SQL 2k.
You can only restore it (painfully) to a 6.5 system and then perform
upgrades on it.
Rick Sawtell
MCT, MCSD, MCDBA|||No can do. You will have to build a SQL 6.5 server, restore the file, then
convert to 7.0/2000. Without the sysdevices, sysdatabases, and sysusages
information, you cannot restore a SQL 6.5 database. Unlike SQL 7.0 and
higher, SQL 6.5 database backups are not self-describing.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Amit" <Amit@.discussions.microsoft.com> wrote in message
news:E15A0D61-F208-4FC8-B7A4-53A7461B24EA@.microsoft.com...
> All,
> My client has give me a 6.5 backup file in a .DAT format.
> I want to restore it in SQL2000.
>|||Hi,
SQL 6.5 and SQL 2000 architecture is different and since the backup restore
is not allowed. So only possibility is:-
1. Restore the 6.5 backup DAT file into SQL 6.5 machine
2. INstall SQL 2000 and service pack
3. Use Upgrade wizard rto upgrade the SQL 6.5 database to SQL 2000
4. Upgrade wizard will copy all the data / objects to SQL 2000.
Note:-
Execute a DBCC and update statistics before the upgrade
Thanks
Hari
SQL Server MVP
"Amit" <Amit@.discussions.microsoft.com> wrote in message
news:E15A0D61-F208-4FC8-B7A4-53A7461B24EA@.microsoft.com...
> All,
> My client has give me a 6.5 backup file in a .DAT format.
> I want to restore it in SQL2000.
>|||In addition to the other posts:
You *might* be able to restore your 6.5 backup on another 6.5 machine even i
f you don't know the
database fragments (master..sysusages etc). But you will end up with data pa
ges where SQL Server
expects log pages and vice versa. For data pages where SQL Server expects lo
g pages, DBCC NEWALLOG
will return 2558 errors (I believe) and you have to physically move the data
. Possibly create script
and transfer all over to a new database. Possibly by rebuilding all indexes.
Not to be taken lightly
if you don't have good 6.5 expertise.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Amit" <Amit@.discussions.microsoft.com> wrote in message
news:E15A0D61-F208-4FC8-B7A4-53A7461B24EA@.microsoft.com...
> All,
> My client has give me a 6.5 backup file in a .DAT format.
> I want to restore it in SQL2000.
>|||Thanks every one for taking time to reply :-)
Regards
Amit
"Amit" wrote:

> All,
> My client has give me a 6.5 backup file in a .DAT format.
> I want to restore it in SQL2000.
>

restoring msdb with SQL 2000

Hi,
I'm running SQL 2000, sp4. I use the following statement to backup msdb:
backup database msdb to disk ='c:\msdb.dat'
then restore with:restore database msdb from disk = 'c:\msdb.dat' with
norecovery
The restore seem to succeed. But I get the following messages:
Processed 1424 pages for database 'msdb', file 'MSDBData' on file 1.
Processed 1 pages for database 'msdb', file 'MSDBLog' on file 1.
Server: Msg 927, Level 14, State 2, Line 1
Database 'msdb' cannot be opened. It is in the middle of a restore.
Server: Msg 3009, Level 16, State 3, Line 1
Could not insert a backup or restore history/detail record in the msdb
database. This may indicate a problem with the msdb database. The
backup/restore operation was still successful.
RESTORE DATABASE successfully processed 1425 pages in 2.985 seconds (3.908
MB/sec).
These messages aren't generated with SQL2005, nor do you see the messages if
you specify 'with recovery' on the restore statement.
I would be appreciative if someone could explain these messages. If I ignore
them, it is still possible to recover the database (restore database msdb
with recovery).
Thanks, HowardIf you want the database to be available for users do not restore it using
'with norecovery', just remove this part from your restore command.
Norecovery is used when you want to apply additional backups. If you see the
status on Enterprise Manager or Management Studio when you are using
norecovery it will show 'Restoring ... ' and no users will be able to connect
to it.
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"Howard" wrote:
> Hi,
> I'm running SQL 2000, sp4. I use the following statement to backup msdb:
> backup database msdb to disk ='c:\msdb.dat'
> then restore with:restore database msdb from disk = 'c:\msdb.dat' with
> norecovery
> The restore seem to succeed. But I get the following messages:
> Processed 1424 pages for database 'msdb', file 'MSDBData' on file 1.
> Processed 1 pages for database 'msdb', file 'MSDBLog' on file 1.
> Server: Msg 927, Level 14, State 2, Line 1
> Database 'msdb' cannot be opened. It is in the middle of a restore.
> Server: Msg 3009, Level 16, State 3, Line 1
> Could not insert a backup or restore history/detail record in the msdb
> database. This may indicate a problem with the msdb database. The
> backup/restore operation was still successful.
> RESTORE DATABASE successfully processed 1425 pages in 2.985 seconds (3.908
> MB/sec).
> These messages aren't generated with SQL2005, nor do you see the messages if
> you specify 'with recovery' on the restore statement.
> I would be appreciative if someone could explain these messages. If I ignore
> them, it is still possible to recover the database (restore database msdb
> with recovery).
> Thanks, Howard
>
>
>|||By the way your restore was sucessful but because you are using with
norecovery the msdb database is not available to users. Regarding the error
messages, the msdb database keeps the backup and restore history of the
databases on the instance, and looks like in this case is not able to record
its own restore operation.
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"Ben Nevarez" wrote:
> If you want the database to be available for users do not restore it using
> 'with norecovery', just remove this part from your restore command.
> Norecovery is used when you want to apply additional backups. If you see the
> status on Enterprise Manager or Management Studio when you are using
> norecovery it will show 'Restoring ... ' and no users will be able to connect
> to it.
> Hope this helps,
> Ben Nevarez
> Senior Database Administrator
> AIG SunAmerica
>
> "Howard" wrote:
> > Hi,
> >
> > I'm running SQL 2000, sp4. I use the following statement to backup msdb:
> > backup database msdb to disk ='c:\msdb.dat'
> >
> > then restore with:restore database msdb from disk = 'c:\msdb.dat' with
> > norecovery
> >
> > The restore seem to succeed. But I get the following messages:
> >
> > Processed 1424 pages for database 'msdb', file 'MSDBData' on file 1.
> > Processed 1 pages for database 'msdb', file 'MSDBLog' on file 1.
> > Server: Msg 927, Level 14, State 2, Line 1
> > Database 'msdb' cannot be opened. It is in the middle of a restore.
> > Server: Msg 3009, Level 16, State 3, Line 1
> > Could not insert a backup or restore history/detail record in the msdb
> > database. This may indicate a problem with the msdb database. The
> > backup/restore operation was still successful.
> > RESTORE DATABASE successfully processed 1425 pages in 2.985 seconds (3.908
> > MB/sec).
> >
> > These messages aren't generated with SQL2005, nor do you see the messages if
> > you specify 'with recovery' on the restore statement.
> >
> > I would be appreciative if someone could explain these messages. If I ignore
> > them, it is still possible to recover the database (restore database msdb
> > with recovery).
> >
> > Thanks, Howard
> >
> >
> >
> >
> >
> >|||Also, when restoring MSDB, make sure your SQLAgent service is stopped as
this service is using the MSDB database
"Howard" <Howard@.discussions.microsoft.com> wrote in message
news:2D037B41-1D79-4207-8916-3964747C395C@.microsoft.com...
> Hi,
> I'm running SQL 2000, sp4. I use the following statement to backup msdb:
> backup database msdb to disk ='c:\msdb.dat'
> then restore with:restore database msdb from disk = 'c:\msdb.dat' with
> norecovery
> The restore seem to succeed. But I get the following messages:
> Processed 1424 pages for database 'msdb', file 'MSDBData' on file 1.
> Processed 1 pages for database 'msdb', file 'MSDBLog' on file 1.
> Server: Msg 927, Level 14, State 2, Line 1
> Database 'msdb' cannot be opened. It is in the middle of a restore.
> Server: Msg 3009, Level 16, State 3, Line 1
> Could not insert a backup or restore history/detail record in the msdb
> database. This may indicate a problem with the msdb database. The
> backup/restore operation was still successful.
> RESTORE DATABASE successfully processed 1425 pages in 2.985 seconds (3.908
> MB/sec).
> These messages aren't generated with SQL2005, nor do you see the messages
> if
> you specify 'with recovery' on the restore statement.
> I would be appreciative if someone could explain these messages. If I
> ignore
> them, it is still possible to recover the database (restore database msdb
> with recovery).
> Thanks, Howard
>
>
>|||Hi Ben,
Thanks for your quick reply. I did consider using 'with recovery' on the
restore statement. The trouble is that msdb does permit 'full' recovery mode.
So you may still need to restore the transaction log to a PIT after restoring
the database. Also, I understand that the msdb was indeed restored despite
the error message. What I really want to know is what to make of the error
message as I work with a program that deals with other people's data and this
type of message makes them nervous.
Thanks again, Howard|||This is a kind of catch-22 situation. Each RESTORE want to write to the restore history tables in
msdb. Since these aren't available (yet) when you restore msdb, that restore history writing isn't
possible. One could argue that SQL server would be smart enough to produce only a warning or similar
in these situations, of course. Perhaps you want to file an entry at
http://connect.microsoft.com/sqlserver for this... Probably MS didn't find this happening often
enough to warrant any major effort... :-)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Howard" <Howard@.discussions.microsoft.com> wrote in message
news:9AE3DA6D-40B3-4577-894C-D9347C11C28A@.microsoft.com...
> Hi Ben,
> Thanks for your quick reply. I did consider using 'with recovery' on the
> restore statement. The trouble is that msdb does permit 'full' recovery mode.
> So you may still need to restore the transaction log to a PIT after restoring
> the database. Also, I understand that the msdb was indeed restored despite
> the error message. What I really want to know is what to make of the error
> message as I work with a program that deals with other people's data and this
> type of message makes them nervous.
> Thanks again, Howard
>|||Thanks for this info. As I said, this is a relic of SQL2000 (SP4). The
problem doesn't appear in SQL 2005. I think I'll take your suggestion and try
to get an official response from Microsoft because at least on of my
customers may be expecting it.
"Tibor Karaszi" wrote:
> This is a kind of catch-22 situation. Each RESTORE want to write to the restore history tables in
> msdb. Since these aren't available (yet) when you restore msdb, that restore history writing isn't
> possible. One could argue that SQL server would be smart enough to produce only a warning or similar
> in these situations, of course. Perhaps you want to file an entry at
> http://connect.microsoft.com/sqlserver for this... Probably MS didn't find this happening often
> enough to warrant any major effort... :-)
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Howard" <Howard@.discussions.microsoft.com> wrote in message
> news:9AE3DA6D-40B3-4577-894C-D9347C11C28A@.microsoft.com...
> > Hi Ben,
> >
> > Thanks for your quick reply. I did consider using 'with recovery' on the
> > restore statement. The trouble is that msdb does permit 'full' recovery mode.
> > So you may still need to restore the transaction log to a PIT after restoring
> > the database. Also, I understand that the msdb was indeed restored despite
> > the error message. What I really want to know is what to make of the error
> > message as I work with a program that deals with other people's data and this
> > type of message makes them nervous.
> >
> > Thanks again, Howard
> >
> >
>
>|||> As I said, this is a relic of SQL2000 (SP4). The
> problem doesn't appear in SQL 2005.
Cool. I didn't know that. So MS did spend some time on this. Thanks for the update. :-)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Howard" <Howard@.discussions.microsoft.com> wrote in message
news:2FA4EC15-34D7-41FA-867F-8DC825A67414@.microsoft.com...
> Thanks for this info. As I said, this is a relic of SQL2000 (SP4). The
> problem doesn't appear in SQL 2005. I think I'll take your suggestion and try
> to get an official response from Microsoft because at least on of my
> customers may be expecting it.
> "Tibor Karaszi" wrote:
>> This is a kind of catch-22 situation. Each RESTORE want to write to the restore history tables in
>> msdb. Since these aren't available (yet) when you restore msdb, that restore history writing
>> isn't
>> possible. One could argue that SQL server would be smart enough to produce only a warning or
>> similar
>> in these situations, of course. Perhaps you want to file an entry at
>> http://connect.microsoft.com/sqlserver for this... Probably MS didn't find this happening often
>> enough to warrant any major effort... :-)
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Howard" <Howard@.discussions.microsoft.com> wrote in message
>> news:9AE3DA6D-40B3-4577-894C-D9347C11C28A@.microsoft.com...
>> > Hi Ben,
>> >
>> > Thanks for your quick reply. I did consider using 'with recovery' on the
>> > restore statement. The trouble is that msdb does permit 'full' recovery mode.
>> > So you may still need to restore the transaction log to a PIT after restoring
>> > the database. Also, I understand that the msdb was indeed restored despite
>> > the error message. What I really want to know is what to make of the error
>> > message as I work with a program that deals with other people's data and this
>> > type of message makes them nervous.
>> >
>> > Thanks again, Howard
>> >
>> >
>>

restoring msdb with SQL 2000

Hi,
I'm running SQL 2000, sp4. I use the following statement to backup msdb:
backup database msdb to disk ='c:\msdb.dat'
then restore with:restore database msdb from disk = 'c:\msdb.dat' with
norecovery
The restore seem to succeed. But I get the following messages:
Processed 1424 pages for database 'msdb', file 'MSDBData' on file 1.
Processed 1 pages for database 'msdb', file 'MSDBLog' on file 1.
Server: Msg 927, Level 14, State 2, Line 1
Database 'msdb' cannot be opened. It is in the middle of a restore.
Server: Msg 3009, Level 16, State 3, Line 1
Could not insert a backup or restore history/detail record in the msdb
database. This may indicate a problem with the msdb database. The
backup/restore operation was still successful.
RESTORE DATABASE successfully processed 1425 pages in 2.985 seconds (3.908
MB/sec).
These messages aren't generated with SQL2005, nor do you see the messages if
you specify 'with recovery' on the restore statement.
I would be appreciative if someone could explain these messages. If I ignore
them, it is still possible to recover the database (restore database msdb
with recovery).
Thanks, HowardIf you want the database to be available for users do not restore it using
'with norecovery', just remove this part from your restore command.
Norecovery is used when you want to apply additional backups. If you see the
status on Enterprise Manager or Management Studio when you are using
norecovery it will show 'Restoring ... ' and no users will be able to connec
t
to it.
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"Howard" wrote:

> Hi,
> I'm running SQL 2000, sp4. I use the following statement to backup msdb:
> backup database msdb to disk ='c:\msdb.dat'
> then restore with:restore database msdb from disk = 'c:\msdb.dat' with
> norecovery
> The restore seem to succeed. But I get the following messages:
> Processed 1424 pages for database 'msdb', file 'MSDBData' on file 1.
> Processed 1 pages for database 'msdb', file 'MSDBLog' on file 1.
> Server: Msg 927, Level 14, State 2, Line 1
> Database 'msdb' cannot be opened. It is in the middle of a restore.
> Server: Msg 3009, Level 16, State 3, Line 1
> Could not insert a backup or restore history/detail record in the msdb
> database. This may indicate a problem with the msdb database. The
> backup/restore operation was still successful.
> RESTORE DATABASE successfully processed 1425 pages in 2.985 seconds (3.908
> MB/sec).
> These messages aren't generated with SQL2005, nor do you see the messages
if
> you specify 'with recovery' on the restore statement.
> I would be appreciative if someone could explain these messages. If I igno
re
> them, it is still possible to recover the database (restore database msdb
> with recovery).
> Thanks, Howard
>
>
>|||By the way your restore was sucessful but because you are using with
norecovery the msdb database is not available to users. Regarding the error
messages, the msdb database keeps the backup and restore history of the
databases on the instance, and looks like in this case is not able to record
its own restore operation.
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"Ben Nevarez" wrote:
[vbcol=seagreen]
> If you want the database to be available for users do not restore it using
> 'with norecovery', just remove this part from your restore command.
> Norecovery is used when you want to apply additional backups. If you see t
he
> status on Enterprise Manager or Management Studio when you are using
> norecovery it will show 'Restoring ... ' and no users will be able to conn
ect
> to it.
> Hope this helps,
> Ben Nevarez
> Senior Database Administrator
> AIG SunAmerica
>
> "Howard" wrote:
>|||Also, when restoring MSDB, make sure your SQLAgent service is stopped as
this service is using the MSDB database
"Howard" <Howard@.discussions.microsoft.com> wrote in message
news:2D037B41-1D79-4207-8916-3964747C395C@.microsoft.com...
> Hi,
> I'm running SQL 2000, sp4. I use the following statement to backup msdb:
> backup database msdb to disk ='c:\msdb.dat'
> then restore with:restore database msdb from disk = 'c:\msdb.dat' with
> norecovery
> The restore seem to succeed. But I get the following messages:
> Processed 1424 pages for database 'msdb', file 'MSDBData' on file 1.
> Processed 1 pages for database 'msdb', file 'MSDBLog' on file 1.
> Server: Msg 927, Level 14, State 2, Line 1
> Database 'msdb' cannot be opened. It is in the middle of a restore.
> Server: Msg 3009, Level 16, State 3, Line 1
> Could not insert a backup or restore history/detail record in the msdb
> database. This may indicate a problem with the msdb database. The
> backup/restore operation was still successful.
> RESTORE DATABASE successfully processed 1425 pages in 2.985 seconds (3.908
> MB/sec).
> These messages aren't generated with SQL2005, nor do you see the messages
> if
> you specify 'with recovery' on the restore statement.
> I would be appreciative if someone could explain these messages. If I
> ignore
> them, it is still possible to recover the database (restore database msdb
> with recovery).
> Thanks, Howard
>
>
>|||Hi Ben,
Thanks for your quick reply. I did consider using 'with recovery' on the
restore statement. The trouble is that msdb does permit 'full' recovery mode
.
So you may still need to restore the transaction log to a PIT after restorin
g
the database. Also, I understand that the msdb was indeed restored despite
the error message. What I really want to know is what to make of the error
message as I work with a program that deals with other people's data and thi
s
type of message makes them nervous.
Thanks again, Howard|||This is a kind of catch-22 situation. Each RESTORE want to write to the rest
ore history tables in
msdb. Since these aren't available (yet) when you restore msdb, that restore
history writing isn't
possible. One could argue that SQL server would be smart enough to produce o
nly a warning or similar
in these situations, of course. Perhaps you want to file an entry at
http://connect.microsoft.com/sqlserver for this... Probably MS didn't find t
his happening often
enough to warrant any major effort... :-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Howard" <Howard@.discussions.microsoft.com> wrote in message
news:9AE3DA6D-40B3-4577-894C-D9347C11C28A@.microsoft.com...
> Hi Ben,
> Thanks for your quick reply. I did consider using 'with recovery' on the
> restore statement. The trouble is that msdb does permit 'full' recovery mo
de.
> So you may still need to restore the transaction log to a PIT after restor
ing
> the database. Also, I understand that the msdb was indeed restored despit
e
> the error message. What I really want to know is what to make of the error
> message as I work with a program that deals with other people's data and t
his
> type of message makes them nervous.
> Thanks again, Howard
>|||Thanks for this info. As I said, this is a relic of SQL2000 (SP4). The
problem doesn't appear in SQL 2005. I think I'll take your suggestion and tr
y
to get an official response from Microsoft because at least on of my
customers may be expecting it.
"Tibor Karaszi" wrote:

> This is a kind of catch-22 situation. Each RESTORE want to write to the re
store history tables in
> msdb. Since these aren't available (yet) when you restore msdb, that resto
re history writing isn't
> possible. One could argue that SQL server would be smart enough to produce
only a warning or similar
> in these situations, of course. Perhaps you want to file an entry at
> http://connect.microsoft.com/sqlserver for this... Probably MS didn't find
this happening often
> enough to warrant any major effort... :-)
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Howard" <Howard@.discussions.microsoft.com> wrote in message
> news:9AE3DA6D-40B3-4577-894C-D9347C11C28A@.microsoft.com...
>
>|||> As I said, this is a relic of SQL2000 (SP4). The
> problem doesn't appear in SQL 2005.
Cool. I didn't know that. So MS did spend some time on this. Thanks for the
update. :-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Howard" <Howard@.discussions.microsoft.com> wrote in message
news:2FA4EC15-34D7-41FA-867F-8DC825A67414@.microsoft.com...[vbcol=seagreen]
> Thanks for this info. As I said, this is a relic of SQL2000 (SP4). The
> problem doesn't appear in SQL 2005. I think I'll take your suggestion and
try
> to get an official response from Microsoft because at least on of my
> customers may be expecting it.
> "Tibor Karaszi" wrote:
>