these queries tell you which databases are consuming most memory in the buffer cache and then you can drill down to which objects in that database are using the most...

1/2 each - final offer.

oh yes.... a point to me I do believe 😉

http://sqlskills.com/BLOGS/PAUL/post/Search-Engine-QA-19-Misconceptions-around-index-rebuilds-(allocation-BULK_LOGGED-mode-locking).aspx

full...

It has to run as SQL in the database engine eventually so yes I would run profiler which will show exactly what was run and can also trap errors.

As it...

Incorrect syntax near '?'.

thats an invalid character. some error in the display. Remove all of them

So you are booting from SAN? thats probably the best way to leverage SAN replication.

From the SQL side there should be NOTHING to do, should all just work once the...

IF the metadata about the databases exist in the system databases on the DR server, they should be usable.

I strongly suggest you set up a test environment and practice the...

Its going to depend on your SAN vendor, the OS you are running and which databases you are replicating (are you doing the system databases?)

Once the steps are done that...

dbcc inputbuffer won't neccessarily tell you the actual sql running at the time you run it, try this query:

--How to isolate the current running commands in SQL Server. This query...

As its a test server and backup space on the backup drive is an issue I would keep the db in simple mode and take a differential backup post the...

posts crossed - in case you miss it

if you want to save space on your backup drive, after switching back to full, take a differential backup and then start your...

if you want to save space on your backup drive, after switching back to full, take a differential backup and then start your log backups again

thread more than a year old!