What sort of data is in the database? If it's mainly text, the backup will compress well. If it's mainly LOB data, it won't.

John

That looks about right, Sean. I was just about to suggest that the last query in the original post was nearly there - it just needs the IN changed...

The first thing to do is copy and paste the error message into your favourite search engine. When I did that, the first result was a blog that looked...

BWFC (12/12/2014)

John Mitchell-245523 (12/12/2014)

I'm no lawyer, but as I understand it, TUPE protects you from any changes that are made...

I'm no lawyer, but as I understand it, TUPE protects you from any changes that are made as a direct...

Alex

Yes, that did exist, possibly up to SQL Server 2000. As far as I know, you can't do it any more. Too much of a security risk, I...

If it's a one-off copy-and-paste into Excel, you can also type a "'" (single quote) into the cell and append the number on to that. That will have the...

You need to copy and paste the plan into a text file and save it with a .sqlplan extension. You can then open it in graphical form in SSIS.

John

Never seen that before. But if I had to guess, I'd say that the backup that was made to that file was interrupted and didn't finish.

John

No, it will only show what backup set(s) are on the backup device (file). Have a read of the RESTORE topic in Books Online.

John

What happens if you do [font="Courier New"]RESTORE HEADERONLY FROM DISK = 'MyFile'[/font], where MyFile is the path to and name of your backup file?

John

Yes, just use the FILE = 6 option in your RESTORE statement.

John

Werner

In order to eliminate the NIC as the cause of the reduced performance, select your query results into a temp table instead of having them returned to the caller. ...

If it's a live server, definitely not. Sysadmin should only be given to DBAs. We don't live in an ideal world, so sometimes we have to make exceptions...

http://msdn.microsoft.com/en-us/library/hh231187(v=sql.110).aspx

John