At work here we use the Ola Hallengran scripts to run out backups to a dedicated backup server. I have added a final step to the user database and log...

Thanks for a great question.

The restore dialogue in SSMS has a GUI front end and works for one database at a time. sp_RestoreScriptGenie can build a restore script for all databases in an instance...

This is a link to a T-SQL and a PowerShell script that can be used to automate SQL Restores. [/url]

I've developed a stored procedure to automate the generation of restore scripts. http://paul.dynalias.com/SQL/_layouts/15/start.aspx#/

The procedure is actually a single SQL query, you can specify a STOPAT point and it works out...

Well done Simon , nice one 🙂

http://www.sqlskills.com/blogs/jonathan/post/Failover-Clustering-without-a-SAN-SQL-Server-2012-and-SMB-for-Shared-Storage.aspx

This is also a good method.

Regards

I don't mind really, if it were easy it wouldn't be worth getting. At the end of the day I just wasn't quite good enough. 90 days before a retake...

I definitely did not pass, no complaints though. The exam was nothing like expected (or prepared for) but it was fair. In 90 days time, I will know what to...

My lab exam is 22nd of October in London, hopefully the builders have finished their drilling and banging in the Prometric center there by now :-/

On PowerShell training all this...

Might be worth checking sys.dm_os_waiting_tasks and sys.dm_tran_lock

Regards

Good luck to you too Simon, hope it goes well Monday. At least during the exam your company won't be able to call you, definitely no phones in the exam...

Thanks Gail, sounds like you nailed it.

I won't be trying anything wacky. From reading what others have said, the best approach seems to be to make a first pass through the entire exam answering what you...

I've been getting intensely involved with service broker, for the 1st time really in depth, at work over the last few weeks. The documentation in BOL is actually pretty helpful...