google log shipping.

You say you restored the database in norecovery mode but it is now in...

are you not able to recreate the same directory structure on the target server as the original server?

Why do you want to restore the master to a different server?

please post the exact error from the restore job.

Is it claiming LSN is out of sequence? Are all the log backups in the share AFTER the full backup you used...

If you are going to restore the master database to another server the directory structure should match. does the directory where tempdb is expected to be exist?

the location of the...

is the subscriber updateable? Thinking you might need sp_link_publication, but not definite.

nice spot. Maybe steve's advertising campaign is paying off and it should read 10,780,000 🙂

so long as you enter the correct database name that code should work fine.

not sure if you want size of the database files or the backup size, but this thread provides a query (see post by sergiy) that returns both for all databases...

Thanks guys, worked a treat. Sergiy you were right about the inner join.

george sibbald (4/27/2009)

---

yes, kill will rollback the transaction. Proof if that is Use kill with the statusonly clause will tell you how rollback is progressing if it takes a while.

as...

yes, kill will rollback the transaction. Proof if that is Use kill with the statusonly clause will tell you how rollback is progressing if it takes a while.

as for locking...

I don't know about CU3 for SP3 in particular, though CUs quite often don't.

In either case the installation will tell you if a reboot is going to be necessary anyway...

the 'with rollback immediate ' is tellin the database engine to alter the state of the database despite people being connected to it (without this clause it would fail if...

nice work barry, you must have slaved other this. You should make a book out of all the chapters once you are done, as Lynn said it would become required...

cheers guys, appreciate it. I get it, get all the databases from sysdatabases first by not excluding in the where clause, rather add another join to get just the latest...