Like Gail stated. The easiest way is to backup the db and restore it into the new SQL Server. Then just drop the tables you don't need.

TEMP tables are stored in TEMPDB as well. You won't know until you look at some code.

Just because there is 30gig of free space doesn't mean that that 30 gig is at the end of the file. The data can be spread all over the...

Steve you are most likely correct. However, if they expect to host companies live production data in the future they have to have an alternate plan to fail over...

The thing is more and more people and companies are embracing 'the cloud'. I don't like it for the obvious security reasons, no control over who behind the scenes...

Same here.

I would LOVE to have a 48 hour outage of every system. Imagine how...

Yes, it isn't enough to just implement some feature. You need to understand it, how to recover it and what you will do in a disaster... and practice a...

Years ago we had construction going on to update our UPS and power for our Data Center. One business day our entire Data Center went down. Come to...

They way I do my refresh db jobs is the first step of the job is the kill step, second step is restore. They happen back to back and...

You don't say what error it is giving you.

I use this SP to kill connections when I restore Prod to test:

Use this as the first step in the restore job:...

FYI: This works... however, you must stop/start SQL Server for the servername within SQL server to take effect.

Dang... my bad.... I was attempting to connect to the server with servername:portnumber.... not servername,portnumber

Thanks for the help!

You are being too vague... but... here is one to start with to see who has what type of rights.

Select

'Login Name'= Substring(upper(SUSER_SNAME(SID)),1,40),

...

Why do you feel you should shrink the transaction log every time you run a trans log backup? You are not gaining anything by doing this. If...

Simply put: The transaction log is growing because you have a lot of a combination of insert, delete, updates going on. By shrinking the log you free up space...