It does depend, but you could take a reasonable server, say an x86 or x64 with 4GB of RAM, 2 cores, and try some common things. Maybe querying some order/order...

An interesting debate. From the overall tone, I think that lots of people use C# for personal reasons, or because they find work with it, not because it's better than...

That's roughly what happens. I think it's transactions that affect pages written to the backup, meaning changed while the backup is in process.

The error shows you are connecting with named pipes. You might have something changed in your SSMS connection dialog. Double check all settings that you are using TCPIP.

Also, the name...

HOW are you connecting? SQL Auth, Windows Auth, what are you typing in SSMS? That is some of the information we need to help you solve this.

The windows machine you...

Jeff Moden (11/12/2009)

---

Heh... I have an odd personal preference... I don't like languages that require semi-colons or line continuation characters. It seems that they should all be smarter than...

finally done getting kids off and feeding the beasts around here. Lucky there's no wind. I'll check the poll now and see what I think of the temperature. I'd like...

I hope I'm not one of the Powers that be. If so, they might kick me out soon. I know I frustrate the higher ups at times. Definitely was always...

OK, if you are using SSMS, you are not connecting from one SQL Server to another. SSMS is a client.

How are you putting in the connection string and are you...

Ian is correct. What happens is that any log records written during the backup are included at the end of the backup file. That way changes to pages are reflected...

There's a history cleanup task in the maintenance plans that you can use if you like. It runs this SQL:

declare @dt datetime select @dt = cast(N'2009-10-15T18:28:54' as datetime) exec msdb.dbo.sp_delete_backuphistory...

It's a connection issue as stated. Can you connect from another workstation/client? Are you allowing connections remotely? What protocol are you using, and how are you connecting from the SQL...

Note that it's a good habit to do all your restores with NORECOVERY and then use Gail's statement to complete the restore. That way if you find another log to...

My daughter will say "el-oh-el, Dad"

I've always preferred LMAO or ROFLMAO

We had hundreds of instances at JD Edwards, and make regular efforts to consolidate things. We did not take a "everything should be consolidated approach", but rather identified underused instances,...