Hi,

Thanks for the reply. I have XML file like the one mentioned below.

0

INFO

...

Thanks a lot. Putting the file number while log restore worked.:-)

Thanks again.

Also when I right click the database ->all tasks->restore which is being backed up I can see the list of all the backups with Full backup.

When I restore the full...

Recovery model is Full. SQL Sever error log shows following things for full database backup and log backup.

Here I am just mentioning first two entries of log backup

2009-03-17 00:18:03.18 backup...

How to check whether replication is messing up with the log?

Regards,

Rohit

Thanks for the reply. There are different jobs running for Full backup as well as log backup. Even though I take a full backup manually,update something and then take the...

I tried disbling the constraints. But it did not work

No we don't have any triggers on it. Also there are no locks. I tried it when no users were working. Still it takes a long time.

The query is running for more than 7 hours and still the task is not completed.

Hi Thanks for the reply. It is one time task. But I have to delete the records before users start using it i.e. before putting it on production.

Thanks & regards,

Rohit

Can I alter a table using Linked server?

Hi Thanks for the reply. Below is the trigger that I am using.

create Trigger TRG_TriggerName

ON

CurrentDB_Table

FOR UPDATE

AS

update ...

Right now I have not scheduled the log back up.Full back up is scheduled after every couple of hours with recovery option "Full".

If I start taking log back up every...

Hi Ananth,

How many records do you have in#table? How many records usually get affected due to update statement?

I suggest if you can avoid using # table and use a table...

For OLTP transaction database the growth percentage is 25%