Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Log file moving Expand / Collapse
Author
Message
Posted Thursday, December 20, 2012 7:29 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, December 17, 2013 2:22 AM
Points: 6, Visits: 133
Hello friends,

I have a question that I have a database "Deparment" in my SQL Server 2008r2 environment It has Data files of 5GB and Logfile is 13GB.

My question is Is that possible we can Move this 13GB log file to another location and create a new log file so that the further transaction can store in new log file which saves my space means my database size will 5 Gb in this scenerio.

Wating for yours suggession?

Thanks
Jitendra
Post #1398968
Posted Thursday, December 20, 2012 7:41 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, August 1, 2014 1:26 PM
Points: 2,242, Visits: 3,645
You probably need to understand more about how log file works and how to manage it. See this link.
http://www.sqlservercentral.com/articles/Administration/64582/





Pradeep Singh
Post #1398975
Posted Thursday, December 20, 2012 7:53 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:00 AM
Points: 42,774, Visits: 35,871
Let me guess... Full recovery model and no log backups. When maintained properly, the space in the log file is reusable. See the recommended article


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 #1398982
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse