I'd go with Jeff's advice here. The other thing to consider is you need tempdb to be this large. Sizing tempdb depends on your application and you need to know...

Management studio doesn't create anything. It submits your code to the server, which compiles and executes it. The server process opens database files and holds them open while it's running....

You cannot move the transacitons from an LDF. That's a log file.

You'd need to do a log backup from production and apply that, but your full restore would need to...

If you want to try a new technology, Powershell can do this.

Do you want info inside SQL Server for something?

there are a few tools that can do this, however it's pretty simple to write this as mentioned above. Lots of scripts here on this site as well that can...

Output the SQLCMD stuff to the same file, appending the data from each. Then you can dig in and build a report.

Master really needs logins moved (and roles)

msdb needs jobs, maint plans, etc. moved. You might be able to script all this stuff out.

Model, what needs to be moved?

I'm not sure what the default time that the data is stored, but I bet that if the report only goes back 10 days, the data is gone. This isn't...

I believe the server security_admin can be given to fix this.

Or set up a job that can run under system context and run sp_change_users_login to sync things up. The logins...

You need a variable to do this.

select @cmd = 'update tableA set '

-- cursor start here

select @cmd = @cmd + @column_name + '= ''value'' where ' + @column_name + '...

There could be lots of reasons, but likely the application is not dealing with the time it takes for something to occur or the load of data being moved.

You haven't...

This isn't something you change with T-SQL, it would be done in the Configuration Manager in 2005 or the Server network Utility in 2000.

select a.value, b.value

from tableA a

inner join tableA b

on a.id = b.parentid

Queries against master have no impact on the server other than using resources to execute the query. There is not reason this should corrupt anything.

If you get this with a local backup, you have IO subsystem issues.