SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Restore Faills


Restore Faills

Author
Message
yogi123
yogi123
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1260 Visits: 401
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.
anthony.green
anthony.green
SSC Guru
SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)

Group: General Forum Members
Points: 62486 Visits: 8594
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?



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
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger


GilaMonster
GilaMonster
SSC Guru
SSC Guru (546K reputation)SSC Guru (546K reputation)SSC Guru (546K reputation)SSC Guru (546K reputation)SSC Guru (546K reputation)SSC Guru (546K reputation)SSC Guru (546K reputation)SSC Guru (546K reputation)

Group: General Forum Members
Points: 546920 Visits: 47732
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, MVP, M.Sc (Comp Sci)
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


Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search