Can you describe the company estate, is it a whole VM estate, all physical tin or a mixture of both?

The first thing I would try and force your infrastructure people...

if you have already created a maintenance plan outside of log shipping to backup your logs then you are fine you dont need to do any manual backups.

in a log...

That error message indicates to me that either the first time logshipping was set up, it completed but missed the creation of a job, or and I would say this...

I would either create a server or database role depending on the scope of work, then assign the nessesary access the person is allowed to complete to that role. ...

If you really wanted to you could put every database mdf/ndf/ldf on the same drive but I wouldnt as you might as well just say can I have my P45...

Hi Kesmond

It seems like you have set LS up to go into standby when the log has finished restoring, there is an additonal check box on the LS section of...

are the commands just simple update statements that are being executed causing the deadlocks in the dl_7.xdl file?

do you have the full query batch around the deadlocking area?

the deadlock image...

The alter database works for TempDB, model and MSDB (and manually copy the files for model and MSDB to the new drive once SQL is stopped) but we always say...

If you do it via to GUI but dont hit OK, instead at the top, there should be a script button, hit the arrow then select where you will want...

There are a number of tools out there which can translate the transaction log for you into a GUI so you can see what happened and when

My personal favourite is...

do you use DTC anywhere in the applications?

we had an issue before where there was a never terminating DTC transaction ongoing and it wouldn't terminate by killing the spid and...

From the sounds of the discussion that was had, it sounded like they wanted the same OLTP DB to be running on both nodes to which I initialy said, hold...

Thanks that was my thought as well that it couldn't be done, just someone was saying they managed to do it before to which I thought was a bit strange.

Yeah I have moved on to powershell anyway, just didnt know if there was a quick way to change between DMO and SMO

ok so scripted all tables and views from the db using SSMS and searched for *= and =* to which brought back nothing.

as SQLDMO is no longer a feature in...