What is your output if you run a RESTORE VERIFYONLY FROM <backup_device> against the TLog backup file to imported?

I use to administer a system which backed up its TLogs at...

Generally, yes, your databases will be available during a backup.

I say generally as a 2000 system I use to administer use to have problems with logshipping when the backup was...

Me too! Didn't spot the tick boxes until too late. Didn't see anything that matched the 2nd answer either. Not a happy bunny !!! :crying: More tea needed.

How do I...

When SQL server restarts, it will be brought into a consistent state. Your uncommitted transaction will be rolled back.

Glad to be of help.

Removed comments as added to wrong topic. :w00t:

Looks like you can with 2008 after all ... 😀

From the BOL. http://msdn.microsoft.com/en-us/library/ms180992.aspx

Automating Administration Across an Enterprise

Automating administration across multiple instances of SQL Server is called multiserver administration....

Fernando-235287 (9/22/2009)

---

Sorry, guys, I did this a few years back with 2000, but totally forgot. Any articles or ways of doing so? I think I am searching with the wrong...

One way is to restore the database into a new database. You can then populate your old table from the contents of the restored database.

Maybe it's just me but I...