GSquared (7/26/2011)

---

Okay. ...

No to I have not run anything using this Server

No, this is the first time that I am trying to run anything on this server and I have never come across it before.

Yes and the version is SQL Server 2008

Thank you

Ninja's_RGR'us (7/4/2011)

---

tt-615680 (7/4/2011)

---

steveb. (7/4/2011)

---

but without the t-log backups you will lose a days worth of data if there is a disaster. since you do not have the ability...

steveb. (7/4/2011)

---

but without the t-log backups you will lose a days worth of data if there is a disaster. since you do not have the ability to do...

GilaMonster (6/29/2011)

---

tt-615680 (6/29/2011)

---

No, we Backup every night through "Database Maintenance Plans" (which is set to delete any backup files that are older then 2 days). So if there should not...

Ninja's_RGR'us (6/29/2011)

---

That would imply that you don't care about the data changes between the full backups. So in the event of a disaster you lose ALL the data since...

Ninja's_RGR'us (6/29/2011)

---

That would imply that you don't care about the data changes between the full backups. So in the event of a disaster you lose ALL the data since...

Ninja's_RGR'us (6/29/2011)

---

That would imply that you don't care about the data changes between the full backups. So in the event of a disaster you lose ALL the data since...

Ninja's_RGR'us (6/29/2011)

---

That would imply that you don't care about the data changes between the full backups. So in the event of a disaster you lose ALL the data since...

Ninja's_RGR'us (6/29/2011)

---

#1 You need to take another full backup NOW. Doing what you did cost you the possibility to restore to a point in time.

#2 Stop shrinking the DB...

Thank you for your help.

I first Backed up the Transaction Log files using

BACKUP LOG DatabaseName WITH TRUNCATE_ONLY

Then I shrunk the Database using the following

DBCC SHRINKDATABASE (DatabaseName, TRUNCATEONLY)

and it...

Kiara (6/23/2011)

---

tt-615680 (6/23/2011)

---

John Mitchell-245523 (6/23/2011)

---

Is your database in Full recovery mode or Simple? If Full, how often do you back up your transaction log? How much of the...

John Mitchell-245523 (6/23/2011)

---

Is your database in Full recovery mode or Simple? If Full, how often do you back up your transaction log? How much of the 135GB is...