The error is related to the transaction log file.

Is that unrestricted also? If so you may be hitting the disk capacity and need a bigger disk.

Increase space in TempDB, set it to autogrow, manually increase the file size, increase space on the TempDB drive if its at capacity.

If your after the certs then 70-463 will be needed to get MCSA and then MCSE when you do 70-464 and 70-465.

I wasn't looking forward to 70-463 as its not...

Can run a profile trace for login failed events to see what its trying to do.

Room

Is the default database online?

Does the state of the database change at any point during the day when the users could be accessing the DB? Daily refresh or something like...

How often does this need to run?

Very ad-hoc you could look at the Import/Export Wizard

Everyday/hour etc I would look at SSIS

Also thanks to Jeff, hadn't seen spreadsheet XML like that...

VLF's you will need to do some sort of loop like using sp_msforeachdb or building a dynamic query that goes and queries each DB individually.

But for the other bits, just...

You need SSDT (SQL Server Data Tools) this is a VS2012 based product and comes built into the SQL media so can be installed via the SQL installer on all...

Do you have SysAdmin / SecurityAdmin role against your login or a group you are a member of on the SQL server?

Builtin Admins hasn't been a member of SysAdmin as...

reported

Have a go at writing a loop to run the query I posted for each DB you have on your server, one thing to...

Cutters

IIRC you need to restart the instance after the restore. Might be tricky with Always On, might have to take all the servers offline.

Block