To understand it better I am pointing you to an excellent article written by Gail:

http://www.sqlservercentral.com/articles/Transaction+Logs/72488/

hp_dba_uk (9/24/2012)

---

Hi there,

I used a script to changed around 60 cust-test DBs from Full to simple recovery model as they were not needed to be in Full recovery mode etc

I...

Thanks Paul for writing such a nice article & clarifying the importance of "WITH CHECKSUM" option when taking the backups! 🙂

Good question. Thanks!

Lokesh Vij (9/19/2012)

---

There is a requirement, details as below:

1) Copy data from transaction table (around million records inserted daily) into a archival table

2) Delete data from transaction table

3) Step (1)...

I thought I guessed correctly what Naseer was trying to ask. So, one easy point for me to end the week 🙂 Thanks.

vsql (9/20/2012)

---

Hello all,

i am a newbie, i want to know the best way to prepare reporting services. i...

Lynn Pettis (9/19/2012)

---

If you are adding and deleting nearly 2,000,000 rows of data, then partitioning may be the what is needed for the archiving process. Depending on the data,...

Nice question! Thanks for reminding the basics.

Thanks for the feedback Paul. Many of us (including me until I didn’t face this...

Thanks for...

Carlo Romagnano (9/17/2012)

---

You need add the clause "FORMAT" to succeed the second statement!

BACKUP DATABASE TestDatabase_1

TO DISK = 'C:\TestDatabaseBackup.BAK'

WITH COMPRESSION

GO

BACKUP DATABASE TestDatabase_2

TO DISK...

Good one. Thanks 😎

Wow! What a thrilling as well as informative thread this has been! 😎

Very good question Wayne. Thanks.