was sqlagent down at the time? Or even SQL itself.

not quite the problem we had here (we had log backups taken outside of the log shipping jobs) but thanks for the post.

I've not come across this, in which version? Under what circumstances would you want to run this and what...

make sure you follow the sql2005 version of those instructions. Its vital you keep the resource database with the master database in SQL2005.

This definitely needs to be done out of...

For SQL2008 onwards the uninstall process takes care of it, no need to restore databases. SQL2005 its uninstall\reinstall so you would need to restore backups (master and msdb at least...

thanks

well thats out of left field.

I don't do replication but I would have thought you would have to reinitialise it from snapshot.

BTW, you don't need to reconfigure logshipping you can use your existing jobs and set up, just reinitialise the backup.

You would be best pausing log jobs, taking a full backup...

ditto

works from 2005 up Jason.

my preferred method would be the alter database command

ALTER DATABASE yourdb

(

NAME = logicalfilename,

FILENAME = N'c:\t1dat2.mdf' --for example

);

then offline the database, actually...

if you are not sure then play safe and put the databases in full recovery mode and set up log backups.

Certainly do that for the two 24/7 databases, the other...

check this out, read the discussion as well

http://www.sqlservercentral.com/scripts/Permissions/76450/

the space figures you are reporting don't add up, reserved + unallocated should = database size - size of log file.

post the results of this query, obfuscate db info if...

it really depends on how frequently you want\can take full backups and what your recovery strategy is, i.e. how much data can you afford to lose.

Generally production databases are in...