Welcome to the forums. Please read the article in my signature for posting these types of questions to the forums. If you could provide create table statements and sample data...

Take a look at this thread and see if that works for you. http://www.sqlservercentral.com/Forums/Topic1460452-2799-1.aspx

I agree with Steve. I have a...

Steve Jones - SSC Editor (4/23/2014)

---

Keith Tate (4/23/2014)

---

Taking the questions/scenarios out of the context of the lab environment (strange environment, limited time, no internet just BOL) would detract from the...

Taking the questions/scenarios out of the context of the lab environment (strange environment, limited time, no internet just BOL) would detract from the experience that most of us had taking...

Glad I could help. 😀

I tested it out with one of my databases and it worked fine, so you should be good to go.

That would work too if you didn't want to allow access to the database during the restore. So basically you would restore all Tlog backups with NORECOVERY until the last...

Have a look at this thread sounds like a very similar situation to yours http://www.sqlservercentral.com/Forums/Topic1413413-1526-1.aspx

Sorry for the short reply, but I have to run 🙂

Parameter @p3 = A.BATCHJOBENDED=@P3 (which is equal to 1)

Parameter @p4 = D.STATUS=@P4 (which is equal to 3)

If you are setting the database to single user how is there connections getting through? I would set the database to single user before each restore and see if that...

I would recommend that you read this book: http://www.red-gate.com/community/books/accidental-dba. At least read the section on memory to better understand the memory architecture.

That is correct, I guess I should have stated that if you want to have 7 GB, after SQL Server has acquired at least 7 GB for the buffer pool...

Download the free pdf while you wait for the hard copy...

Well that is the error you get when you don't have the proper access, but let's try this a different way. Right click the server in Object Explorer and select...

It looks like you don't have the "ALTER SETTINGS" server-level permission on this instance. Can you get that or can you have someone grant that to you? If not, then...