32767 databases per instance - found in BOL

Re memory I think it is limited to the amount the OS can use, this information is available on the microsoft technet site....

RDP to you machine, Then RDp to the server, when signed into the server click the pin on first machine title bar at the top of the screen, so the...

I have done the before, and i was able to minimise the third RDP hop, so to speak, to minimise the server session to get back to the RDP session...

Have a read of Tony Robinson's blog post here, it may help you answer your question:

http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/08/17/948.aspx

pankaj.baluni (1/6/2010)

---

log backup for log3 and log4 didn't happen. Appreciate your quick detailed reply on this.

Furthermore, if you can seperately mention the steps for all three, would be much...

krayknot (1/5/2010)

---

sanketahir1985 (1/5/2010)

---

as Shawn Melton said

1. check for free space on drive where tempdb is stored

&

2. Try to truncate log of tempdb only if no users are using tempdb...

You have a few options including SSIS and also OPENROWSET in TSQL.

Checkout this URL for some further info:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926

Edit: An after thought, You will have to be on the 2007 version...

You could try excuting in smaller transactions/batches allowing the log to be recycled and not use all the space.

This script here probably answers your question:

http://www.mssqltips.com/tip.asp?tip=1601

I guess the first question would be why do you want to give a user role such high access rights?

Firstly there is no need to to enable AWE on 64bit systems...Thats a setting to allow 32bit systems to access more than 4GB

When you set the Min and Max memory...

I'm not entirely sure what you need or what you are after...In terms of table space used you can try, amongst others, the tip provided in this link:

http://www.mssqltips.com/tip.asp?tip=1177

In terms of...

I don't think you can take a log backup in simple mode...Cooler might be right about Full recovery though.

I'm no expert on peer to peer replication but I would suggest...

Its possibly its exactly what it says on the tin, so to speak...Have a look at this post see if it helps

http://social.msdn.microsoft.com/forums/en-US/sqldatabaseengine/thread/7e36aa04-00ce-46a8-9a29-f63f4ac3b6b5/

So when the backup is taken the DB is in multi-user mode but when restored onto another box the DB is in Single User mode.

Have you tried this on...