This question is just down right confusing and not very clear, as indicated by the number of "WRONG??" answers! It should be discarded.

I had been told trhat backing up to a remote device or UNC was not supported by Microsoft. We have had varying luck with this. Sometimes it works, sometimes it...

Sql Server should slowly release the memory. We have had an issue with this same situation running under Windows 2003 OS in a clustered environment. For this and other reasons, we...

Is this SQL Server running on your work station? If so, is it running under your user accounts? If so, have you changed your password lately? If nothing else works,...

Did you try using your login? Try using SA and the proper password.

Assuming you have the backup on the same machine:::

The fisrt thing to do is kill the spid's in the database:

DECLARE @spid varchar (10)

DECLARE @spidconv varchar (4)

DECLARE @sql nvarchar(1000)

DECLARE...

Or in this case, ISQL?

Can you access SQL Server from osql command line?

I have run into the same situation. I set up a job to copy the database backup to another server (which you will not have to do) and restore the...

Oh, one more thing!

TEST, TEST and TEST all your backup/restore and disaster recovery plans!!!

Just a few more things off the top of my head:

Do check the maintenance plans for all!

Check disaster recovery plans, contigencies!

Change password for SQL service accounts and SA!!!!

Get data models,...

I would also add to the list:

Backup and restore testing, along with transaction dumps and differentials (if used.) PRACTICE restoring and applying these. Also, update (or create) Disaster recovery procedures for...

Don't deduct points from those that answered the other correct way. Remember, there is more than one way to get the job done. One way may be better, but that does...

 BOL says

B. Enable the 'text in row' option for table 'orders' in the Northwind database, and set the inline limit to 1000.

EXEC sp_tableoption 'orders',...

One reason could be what was happening to the database at the time of shutdown. SQL Server has to apply all active transactions then backout all uncommitted tranasctions. So, depending on...