Restore Faills

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Restore Faills

Restore Faills

Rate Topic

Display Mode

Topic Options

Author

Message

yogi123

Posted Tuesday, September 04, 2012 8:38 AM

SSC Journeyman

Group: General Forum Members
Last Login: Friday, May 10, 2013 2:47 PM
Points: 83, Visits: 244

Hello

i need your best suggestion.

Here is scenario.

I have a Production server and we backup that server and restore to DAYB server everyday.
Right now Production server's Transaction log is growing to 20 GB and we are running out of space on DAYB server. we have only 17 GB free space on it.

so my manager is suggests me,
truncate Transaction log for temporary fix on Production server. The Data File on Production is 95 GB so is that worth to truncate Transactional log file only for restore purpose on DayB?

Whats Your Suggestion, Please reply me.

Thanks in Advance.

Post #1353946

anthony.green

Posted Wednesday, September 05, 2012 1:48 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

Managing Transaction Logs - http://www.sqlservercentral.com/articles/Administration/64582/
Accidental DBA Guide - Chapter 8 - http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

The only way to "truncate" your data file would be to delete data, shirnk the file then rebuild all your indexes which could created a bigger file that what you already had so I would leave that alone.

As for the log, I take it the recovery model of the database is in FULL, do you use logshipping or backup the transaction log regular for restoring purposes?

Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1354363

GilaMonster

Posted Wednesday, September 05, 2012 2:03 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 3:18 PM
Points: 37,744, Visits: 30,025

Add more drive space to server B.

Seriously, if the DB is growing, it's growing. Unless you decide to archive data and hence free up space in the data file, the DB will keep on growing.
Shrinking a DB that's going to soon fill the drive because of data growth is a futile approach. The data volumes are still growing, shrink doesn't compress or remove data

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1354369

« Prev Topic | Next Topic »

Permissions