At a guess the database consists mainly of one large table, so you have one big transaction, so one big log backup.

If so two options: use dbcc indexdefrag instead...

is it that its taking the tran log backup the full duration of the reindex job to run? what does the tran log job history record for run times of...

the nodes...

although note that the OP has later stated he set up a maint. plan to do his trn log backups, so the script posted earlier would no longer be relevant.

MArker...

oops, I missed that too :blush: Marker, that would explain why...

any chance there is a full backup running at this time? This would prevent the log backup running.

quickest and easiest way to do this is to create a maintenance plan via SSMS. Use transaction type from the backup task.

you should have used recovery, not norecovery

quickest way out of it:

open a query window and run

restore database yourdbname with recovery

jmanly (1/14/2009)

---

Although our HA and DR solution are to be one and the same, and are based on flat file SAN-to-SAN copies, i still wanted to make sure we could...

cheers bruce, I hate to ask such questions sometimes but you never know whos going to come along in the future and read this so its best to complete the...

Bruce,

thanks for posting solution. Would be remiss of me not to mention it just in case, but you know to do a full backup immediately after truncating the log?

any way...

try BACKUP LOG xbobo WITH TRUNCATE_ONLY

6.5 compatibility mode in 2005? wow. you are probably going to often find syntax problems running on that out of date a compatibility

out of...

What you really get with the enterprise edition is the high availability and scale up functions that make the edition 'enterprise' wide, so if you don't need or currently use...

jncarter (1/12/2009)

---

If all of your paths are staying the same and you can handle some downtime then to me the easiest is to install sql on the new server at...

please everybody, stop it.

I feel like Chandler out of Friends, there are so many stupid comments I want to come back with, but I know I shouldn't, its killing me.

:w00t: