agreed don't shrink the log unless you really have no choice.

just to answer your questions:

truncating the log will break the LSN chain and therefore break log shipping. However a log...

shivrampal (2/24/2010)

You can try below options:-

1) Collect current instance configuration using sp_helpserver

2) Drop the old server and create a new one.

sp_dropserver ‘old_name’

go

...

use sp_help_revlogin to generate details for the user on the primary. load the output from that into the secondary. That will bring the sid over and the user will no...

no its not. SQL 2008 optimiser uses stats differently, have you updated your stats?

nope, you would have to uinstall\reinstall, and that doesn't seem worth it to save a bit of typing 🙂

if you make abc\btsadmin the owner of the database it will have all other rights by default.

personally I would then run another checkdb to make sure the DB was now clean.

A backup is the size of the USED space within a database file. Backup does not backup empty extents.

run sp_spaceused against he database, you will see that 'reserved' amount is...

sorry, I see more than 10 lines of code I go into a coma and I only have so much time. This line strips out the newest full backup for...

pick the bones from thsi there may be some useful bits for you. I would look to xhange the exec (@myquety to an sp_executesql for security reasons.

/******************************************************************************************************************/

/* looks for...

Roy Ernest (2/23/2010)

george sibbald (2/23/2010)

cheers Roy for joining...

cheers Roy for joining in. More the merrier,...

and you don't have a backup of this database?

can i suggest to you that you google that error for information and run a DBCC checkdb all_errormsgs, no_infomsgs just to see...

any takers. We need DBCC timewarp over here

did you check your SQL errorlog for clues as to why database might be suspect?