query sys.dm_os_performance_counters

A full backup is consistent at the time it completes, so in this case it would contain the changes held in the 12:45 log backup.

note - if all you want to do is re-initialise log shipping from a new full backup you don't need to remove and recreate the log shipping jobs, the existing...

You can drop the database. or just restore over it with your new full database you are using as a starting point.

Lowell is demonstrating the principle that an army marches on its stomach

if she is not meant to be using the sa account, go and ask her why she tried to 🙂

ALL transactions are logged, there is no way to prevent that. You will either have to size your transaction log so it can cope with the update or preferably batch...

she must have tried to connect with the sa id. Look in the SQL errorlog for the same time, if you have failure auditing on you should see the logon...

if its at 34GB on the secondary it must be the same on the primary. Run the shrink on the primary and the effect of the shrink will be copied...

it will be recorded in the default trace

thanks. so do it as dynamic sql then?

this might just be a language thing, but the conclusion is

log shring - indexes don't need rebuilding

data shrink, indexes will need rebuilding (by a seperate job you build and run...

Little Nick (7/25/2012)

---

Ok sir. I will find the script.

1. What's the different between shrink data file and shrink log file?

2. Which one (shrink data / shrink log) will enforce...

I am afraid I don't, I'm sure there will be one in the scripts section of this site.

Having read Gails blog. you are aware of the pitfalls of what...

it can be done via SSMS (right click database, all tasks, shrink file) but the command is dbcc shrinkfile(logfile logical name, size in MB)

However, what recovery mode is the database...