Can you detail the step by step process you performed?

Did you backup and restore the encryption keys?

What caused the database to go into recovery?

Someone restore the DB and not issue a RECOVERY command?

Someone backup the tail log and issues with NORECOVERY?

Restarted the SQL service?

Something has a lock on the information your after.

Monitor for blocking while your expanding and see what is stopping you.

Jobs in SSMS for SSRS mean reports which are currently being run.

If your trying to view job details on subscriptions, you need to checkout the SQL agent.

The following script will...

Use the import export data wizard to import the data.

Post the full detailed output of the command

create a server side trace, then just before the jobs start, have a job which starts the trace, to stop it ensure you put a stop time in the create...

bugg (2/6/2013)

---

Steve Jones - SSC Editor (2/5/2013)

---

A couple things: AlwaysOn is Enterprise only. I forgot about that, so your read only replica is going to be core licensed if you...

Between 6pm and 7am you dont do transaction log backups, during that time the log cannot be marked as re-usable so that is why you have a huge transaction log...

Wont be able to leverage windows authentication, everything would have to be SQL auth.

Should you need to run backups to network drives etc will be a pain as you will...

dont cross post, it fragments replies and wastes peoples time

all replies here http://www.sqlservercentral.com/Forums/Topic1416459-1292-1.aspx

dont cross post, it fragments replies and wastes peoples time

all replies here http://www.sqlservercentral.com/Forums/Topic1416459-1292-1.aspx

You will want to look at a calendar table

Something like this

Calendar Table - http://www.sqlservercentral.com/scripts/Date/68389/

Please follow the second link in my signature on posting code and data for the best help, that will then give us a play pen to test ideas on to...

An admin to SQL or an admin on the windows host?

What browser are you using?