You may need to shrink msdb after a large cleanup.

Are you able to restore via the GUI now?

There is your problem. You have LOADS of backup history. The GUI is trying to...

What do these queries return?

SELECT COUNT(1) FROM msdb.dbo.backupfile;

SELECT COUNT(1) FROM msdb.dbo.backupfilegroup;

SELECT COUNT(1) FROM msdb.dbo.restorefile;

SELECT COUNT(1) FROM msdb.dbo.restorefilegroup;

SELECT COUNT(1) FROM msdb.dbo.restorehistory;

SELECT COUNT(1) FROM msdb.dbo.backupmediafamily;

Are you running SSMS locally or on the server?

This sounds like a job for the Geometry data type and spatial functions. The following query works for your example.

IF OBJECT_ID ('dbo.SpatialTable') IS NOT NULL

DROP TABLE dbo.SpatialTable;

GO

CREATE TABLE SpatialTable

...

If your end time is in the next day you will need to add a day to your date parameter.

WHERE MyDate BETWEEN CAST(@date + StartTime) AND CAST(DATEADD(DAY, 1, @date) +...

The BCP utility has a batch parameter that allows you to specify the number of records to group in a transaction. If something happens during the BCP process, only the...

http://en.wikipedia.org/wiki/Project_plan

A project plan requires a project....

Paul Randal wrote an excellent article on the subject.

http://technet.microsoft.com/en-us/magazine/2009.07.sqlbackup.aspx

Hany Helmy (9/3/2013)

---

I have to disagree with this answer as per MSDN:

"Transactions Durable: After the database engine acknowledges that a transaction has been committed, its changes are persistent in the...

You're welcome.

The reason you cannot...

Yes the last character is a...

Your data type is CHAR(24) but the string is 23 characters long. If the last character is a TAB or NUL then it will fail. Does this query return 9...

Oracle has Label Security Policy. You will need to ask an Oracle forum for help.

Excuse the type in the image, the comment should read -- Hit Ctrl+7