Good question. Please refer to final explanation in below link.

http://www.sqlnewsgroups.net/sqlserver/t12969-what-does-runnable-mean-sql-server.aspx

Hope this answers your question

You are welcome 🙂

Check for the files that could be removed from the backup drive. Old backup files, unwanted files etc.

What level of privileges you have on system

You won't be able to take the backup directly on to your local machine.

First let the backup command run to take the backup on server location

and then copy...

You could refer below link which would give you an idea.

http://www.databasejournal.com/features/mssql/article.php/2246271/Managing-Users-Permissions-on-SQL-Server.htm

It can be done. I had come across one such setup few years back.

What backups are you referring to?

Thanks for the question. I didn't have an idea on this one.

Also, make sure you are having the latest service packs installed. Otherwise, you would see some peculiar error messages on your maintenance plans.

Can you check the error log, what message you get.

C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG

Thanks for the question, I haven't encountered this before. Found a related link.

http://www.tek-tips.com/viewthread.cfm?qid=1186640&page=189

Hope this helps.

Thank you Gail

mohammed moinudheen (2/8/2011)

---

GilaMonster (2/8/2011)

---

Shutdown shuts the SQL instance down, not a database. It's possible to detach a database and not have it cleanly shut down, primary example if the log...

GilaMonster (2/8/2011)

---

Shutdown shuts the SQL instance down, not a database. It's possible to detach a database and not have it cleanly shut down, primary example if the log is full.

Clean...