JoshDBGuy (3/28/2014)

---

If it's simple recovery, after a transaction has been fully committed the space used should be reused. If it's in full recovery, you need to run t-log backups for...

Grant Fritchey (3/28/2014)

---

Sure sounds like you're either not backing up transaction logs or not backing them up often enough. Read more about it here[/url].

It's also possible that you have a...

It was set to Full until this morning but one of our DBA put the DB to Simple recovery mode.

Thank you Sir!;-)

I just want to make sure that I understand you correctly.

I can have 1 instance for 2 databases and if I need to refresh it from the production "TEST" to...

We were just moving the databases because we had 2 databases using the same drive. We just wanted to put them on a separate drive, so if 1 runs out...

Unfortunately, we did that in prod...

Thanks for replying.

This is how I ended up setting the environment. Please let me know if its OK.

Since it's only 8 GB in size, I am taking full...

Thanks Perry

HanShi (3/11/2014)

---

Do the tables hold data for a single client,...

HanShi (3/11/2014)

---

What do you mean with the above quoted phrase:

1. two instances (with each one database) on the...

Thanks for the reply but I am not moving DB to another instance.

Done.

Thank you so much everyone for taking some time out to help me....

Well, I was able to download it with no problem but I don't know what .iso extension is and how to run the .exe?

so this one should be OK?

http://www.microsoft.com/en-us/sqlserver/get-sql-server/try-it.aspx