If your transaction logs are getting big even in SIMPLE Recovery Mode, could it possibly be that you have a great deal of DML occuring without commits? INSERTs, UPDATEs...

Your Name Here (2/26/2013)

---

RedGate has a wicked awesome tool called Virtual Restore. I can't remember the limitations but they do offer a ...wait for it...

<angels singing>

--->[FREE]<---

</angels...

Of course it will! It doesn't even need a clean shutdown because every time a SQL Server database starts, it performs a recovery, whether we want it to or...

The focus for my answer was actually based around the phrase "the absolute need to have SQL Server Logins". Are they truly necessary? In the vast majority of...

Are the Batch jobs running BULK inserts for example? If so, then for the period of the batch job running you could place the affected database into the Bulk-Logged...

Actually, it can be faster and more reliable than a backup and whats more it will always be consistent. The reason for that is in what happens when the...

How big is the mdf file? Can you tolerate a little downtime?

I ask because I find the simplest way is to copy the mdf to the DEV environment and...

You could also create an SSIS Package very easily to perform the move including the SIDs

I did miss the post! Never mind! Glad you got it sorted though!

There is absolutely no design aspect to it at all!

Users are assigned to OUs by your AD Team and are already in your Domain. The only thing...

Firstly create your user login at the instance-level and map the user to the database you want access to.

Secondly, from the Security tab of the database, assign the user the...

opc.three (3/14/2013)

---

sa is like the Windows "Administrator" account for the instance. When logged in as sa you can do any action on the instance. Lots of people, including myself, like...

Just to clarify: When you change to mixed-mode authentication from Integrated Security the 'sa' account is by default disabled. If it is enabled then it is because a...

Additionally, and where possible, I would leave the database with Integrated Security only. I know of very few instances where there is an absolute need to have an SQL...

Please please please read the documentation, take a course or at least sit down and read a book! Security is the single most important aspect of data management and...