ou were given are
incorrect or at least confusing.
Do not create the database first, will only mess for you. You can delete you
r current database.
Then just create the backup device and do the restore. The database is creat
ed along with the
restore process.
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ls
erver
"Chris Coates" <ccoates@.gfs.com> wrote in message news:eAdEGRB5DHA.2760@.TK2MSFTNGP09.phx.gbl...[QU
OTE]
> I am replacing an old SQL7 Server with a new server that runs SQL 2000. I
> was given directions on how to do this and was told to restore the SQL7
> databases to the new server.
> In order to do this I created an empty database with the same name on the
> new server, created a backup device and ran a backup of the empty database
.
> I testes a restore of the empty database and it worked fine. I then replac
ed
> the empty database .BAK file with the latest .BAK database backup of the
> original database and attempted a restore.
> I get the following error.
>
>
> The SQL Error Log shows the following message:
> Bypassing recovery for database 'Continuum' because it is marked IN LOAD.
>
> What am I doing wrong?
>
> Thanks for your help.
>
> ccoates
>
>[/QUOTE]Also, unless you are going to restore additional transaction log backups,
make sure you check the option that says "Leave Database Operational. No
additional transaction log backups can be restored". That is on the Options
tab of Restore database.
You can restore over an existing database so long as no one is using it |
you check force restore over existing database on the options tab | and make
sure the destination file locations are correct.
****************************************
***************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.NOMORESPAM.yahoo.com
Please remove NOMORESPAM before replying.
Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.
This posting is provided "as is" with no warranties
and confers no rights.
****************************************
***************************
"Chris Coates" <ccoates@.gfs.com> wrote in message
news:eAdEGRB5DHA.2760@.TK2MSFTNGP09.phx.gbl...
quote:
> I am replacing an old SQL7 Server with a new server that runs SQL 2000. I
> was given directions on how to do this and was told to restore the SQL7
> databases to the new server.
> In order to do this I created an empty database with the same name on the
> new server, created a backup device and ran a backup of the empty
database.
quote:
> I testes a restore of the empty database and it worked fine. I then
replaced
quote:|||Hi,
> the empty database .BAK file with the latest .BAK database backup of the
> original database and attempted a restore.
> I get the following error.
>
>
> The SQL Error Log shows the following message:
> Bypassing recovery for database 'Continuum' because it is marked IN LOAD.
>
> What am I doing wrong?
>
> Thanks for your help.
>
> ccoates
>
>
Add on to Tibers post, perform these steps
1. Copy the SQL 7 backup to D:\mssql\backup\dbname.bak
2. Execute the below command from Query analyzer
Restore filelistonly from disk='D:\mssql\backup\dbname.bak'
The above command will give you the details of Logical name and Physical
name
3. Create a folder in D drive (D:\mssql\data) where your .MDF and .LDF
resides
5. Execute the below command from Query Analyzer
restore database dbname from disk='D:\mssql\backup\dbname.bak' with
move 'logical_dataname' to 'd:\mssql\data\dbname.mdf',
move 'logical_logname' to 'd:\mssql\data\dbname.ldf',stats=10
The logical_dataname and Logical_logname should be taken based on the output
of Restore filelistonly command (Step 2)
6.Create your logins , similar to SQL 7
Thanks
Hari
MCDBA
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:e3zY5UB5DHA.2656@.TK2MSFTNGP11.phx.gbl...
quote:
> I assume that you were given a database backup file. Then the instructions
you were given are
quote:
> incorrect or at least confusing.
> Do not create the database first, will only mess for you. You can delete
your current database.
quote:
> Then just create the backup device and do the restore. The database is
created along with the
quote:
> restore process.
> --
> Tibor Karaszi, SQL Server MVP
> Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
quote:
>
> "Chris Coates" <ccoates@.gfs.com> wrote in message
news:eAdEGRB5DHA.2760@.TK2MSFTNGP09.phx.gbl...
quote:|||Hi Chris,
I[QUOTE]
the[QUOTE]
database.[QUOTE]
replaced[QUOTE]
LOAD.[QUOTE]
>
Thank you for using MSDN Newsgroup! It's my pleasure to assist you with
your issue.
From you information provided, you encouter a error message 'Bypassing
recovery for database 'Continuum' because it is marked IN LOAD.' when you
were restoring a backup file which is from SQL 7 to SQL 2000, right?
Thanks to our MVP and other community members' replies. It is not necessary
to create a new database in backup and restore process and they have
provide the proper steps for backup and restore. Here I just want to add
something more that when restoring backup sets from an earlier version of
SQL Server, a database upgrade may be required. This upgrade is performed
automatically when WITH RECOVERY is specified. That is:
restore database database_name from disk='you_back.bak' with recovery
Hope this helps. If you still have questions about it, please feel free to
post new message here and I am ready to help!
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.sql
No comments:
Post a Comment