So the job that takes the backup, there is nothing in there that pops the db in single user node, takes the backup, then pops it back into multi_user mode?

If...

Is it definately single_user not restricted user? I know you can leave a database in restricted mode when preforming a restore but when i try to specify single_user SQL throws...

Looks to me that your winfas user is infact the database owner, which is why it is aliased to the dbo user.

Does the job definately not exist? It does not exist in the agent?

Is it possible that the job is there but the schedule is not set correctly?

I guess you can...

It really depends on the the data type of the column in question.

I was chatting about clustering with Robert Davies and a few other Microsoft guys over on linkedIN (Also Alan Hirt agrees in his book), who are not happy with the...

A log backup failure will get logged in the error log... You can query the log to get this info with the following code:

*/

CREATE TABLE #ErrorLog (

LogDate...

As you said you can also get this information from the server properties in Management Studio.

The account that is running the restore will need permissions on the share to access the file.

Sounds like homework.

If you actually research/google each question you asked the first search returned on each questions gives an explanation and answers your questions...This should help you learn and then...

How do we think the Cloud will affect the 'employability' of the DBA?

Do we think it will reduce the amount of DBA jobs available? (as a results of adavantage 'Free...

PS I'm guessing you will struggle to run the SSIS copy logins ssis package at the time of failover...I'm guessing that the reason for the failover recovery will be...

Logins are not logged shipped. They live in the master database.

User are located in the user database and will be logged shipped....Thus creating orphaned users.

so in this case i guess...

SP3 has been out for a while...i guess the best answer is 'it depends'

If your test environment needs to replicate your production environment. In most cases a test environment would...

You will need to recreate the logins on the secondary log shipped server so the sids of those login match the users in the database.

The users in the database (which...