Restore database question

Hello,
I would like to restore my database what come first,
I first restore the transaction log and after the data backup
InaNo,
first you restore your most recent full backup, then you apply the
transaction log backups, in order.
- Baileys
ina wrote:
> Hello,
> I would like to restore my database what come first,
> I first restore the transaction log and after the data backup
> Ina
>|||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
"ina" wrote:
> Hello,
> I would like to restore my database what come first,
> I first restore the transaction log and after the data backup
> Ina
>|||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
"ina" wrote:
> Thank you but when I select one log all the log of the day are select
> together.
>|||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
"ina" wrote:
> 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
>|||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
"ina" wrote:
> yes I have done it, but I am newbie and I do not know how to understand
> that file yet. :(
> Thanks
> Ina
>|||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
"ina" wrote:
> 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
>|||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
"ina" wrote:
> 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
>|||thank to you :)sql