Differential backups and transaction logs.

Hello. it would be great if someone could help me.
I have a large database (18GB) which is being backed up on the Monday
of every week. Transactions logs are taken every 15mins during the day
and then a diff at the end of the day. My question is this, if a take
a differential at the end of the day can i still restore the
transaction logs from that day after restoring the full backup? I can
restore the full and differentials then the logs fine but when i try
and restore say the full and the transactions it complains that there
is a previous log which there isnt.
Any help would be great at this point.
Try out once again. I have gone thorugh lot of transaction log loads, it
didnt caused me any trouble. I faced the same issue when we transfer it to DR
server, sometimes FTP fail so manually copies it and go for log load which
works fine. Can you post the Error you getting, in that there will be
timestamp saying till what time load happend.
Thanks,
Sree
[Please specify the version of Sql Server as we can save one thread and time
asking back if its 2000 or 2005]
"bungy" wrote:

> Hello. it would be great if someone could help me.
> I have a large database (18GB) which is being backed up on the Monday
> of every week. Transactions logs are taken every 15mins during the day
> and then a diff at the end of the day. My question is this, if a take
> a differential at the end of the day can i still restore the
> transaction logs from that day after restoring the full backup? I can
> restore the full and differentials then the logs fine but when i try
> and restore say the full and the transactions it complains that there
> is a previous log which there isnt.
> Any help would be great at this point.
>
|||Thanks for the help but I found out what the problem was. zip extract
script that was extracting the files wasnt working correctly and the
sproc that is doing the restore wasnt right. Its hard if you didnt
write the bloody thing yourself.
Many thanks,
Sreejith G wrote:[vbcol=seagreen]
> Try out once again. I have gone thorugh lot of transaction log loads, it
> didnt caused me any trouble. I faced the same issue when we transfer it to DR
> server, sometimes FTP fail so manually copies it and go for log load which
> works fine. Can you post the Error you getting, in that there will be
> timestamp saying till what time load happend.
> --
> Thanks,
> Sree
> [Please specify the version of Sql Server as we can save one thread and time
> asking back if its 2000 or 2005]
>
> "bungy" wrote: