Hello,

I would like to restore my database what come first,

I first restore the transaction log and after the data backup

Ina

No,

first you restore your most recent full backup, then you apply the
transaction log backups, in order.

- Baileys


ina wrote:
Show quoteHide quote

Hi Ina

How you restore the database will depend on the your recovery mode and what
backups you have.

If you have a full backup and transaction logs check out:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_7_backpc_4zzt.asp

If you want to restore to a point in time check out
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_7_backpc_18ah.asp

If you have a full backup, differential backup and transaction logs check out: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_7_backpc_18ah.asp

If you use the second or third method make sure you backup the log first (as
shown in the first link)

John

Show quoteHide quote

Thank you but when I select one log all the log of the day are select
together.

Hi Ina

I guess you are trying to use EM rather than T-SQL?

You still have to restore each log in order, and I believe EM will do this
for you and each log backup in the bakup set up to the log backup that you
select will be checked. i.e. if you had a full backup and a two log backups
then if you selected the first log backup it would check the full backup and
the first log backup, it would then restore the full backup followed by the
log backup. If you selected the second log backup all files would be selected
then the full backup would be restored followed by the log backups in order.

HTH

John
Show quoteHide quote

thank you! I have a problem with my restore. So I have this error Error
Database in use. Exclusive access could not be obtained because the
database is in use. Restore database is termatting abnormally

the database is  not in use.

Ina

Hi

I have answered this in your other thread. Your results from sp_who2
indicate that there are connections using the database.

John

Show quoteHide quote

yes I have done it, but I am newbie and I do not know how to understand
that file yet. :(

Thanks

Ina

Hi Ina

Time spent reading Books Online will help you, there is a wealth of
information in it. You can get the latest version oof Book Online for SQL
2000 from http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

John

Show quoteHide quote

thanks, John do you think the problem could be because I am using the
sa login instead of the login of the database I would like to restore?
I have done everything I could but still the same error active database
is in use.

Ina

Hi

You can only restore the database if there are no connections, you need to
find out why you have these other connections and make sure that they get
disconnected.
Make sure that your own connection is not blocking the database restore by
using the USE command e.g. USE MASTER if you are in Query Analyser.

Once you have managed to disconnect all the users you will be able to
restore the database.

John

Show quoteHide quote

thanks John,  I understood the problem is that the service connected to
this database, all time long connect itself to the database (the famous
tester user). I need to disable the service in order to restore the
database.

I really appreciate your help because thanking you I understood a
little more the restore with sql server.

Ina

Hi Ina

It's good to know you resolved the problem :)

John

Show quoteHide quote

thank to you :)

IA64 bit Performance vs X64 - Update statistics
Statistics and Maintenance
Problems with my database creation script
Contents of FileGroups
monitor sql backups
xp_cmdshell PSCP in SQL Server 2000 problem
"Planning" a database enviroment - a bit off topic
"Name" Data Type?
JDBC connection
2000 DB in 2005