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 123»»»

shrinked my ss2k5 log file by below option Expand / Collapse
Author
Message
Posted Wednesday, October 07, 2009 11:58 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, April 10, 2014 6:28 PM
Points: 1,199, Visits: 1,898
Sorry for the wrong entry in sql7,2000 group..

Dear All,


I have shrinked my ss2k5 log file by below option and I have got my log file from 10GB TO 10MB but where is the rest file ,I have not got it.Please help. I want that log files immediately.

tasks-->shrinks--->files--->logs---->empty files by migrating the data into same file group(last option)

Thanks,
Ajay


Thanks

Post #799717
Posted Thursday, October 08, 2009 2:21 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 @ 4:21 AM
Points: 41,507, Visits: 34,422
Why are you trying to shrink (empty) a log. What's the goal here, what's the reasoning?


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 #799772
Posted Thursday, October 08, 2009 3:08 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 2:43 AM
Points: 2,723, Visits: 1,090
guptaajay1985 (10/7/2009)
Sorry for the wrong entry in sql7,2000 group..

Dear All,


I have shrinked my ss2k5 log file by below option and I have got my log file from 10GB TO 10MB but where is the rest file ,I have not got it.Please help. I want that log files immediately.

tasks-->shrinks--->files--->logs---->empty files by migrating the data into same file group(last option)

Thanks,
Ajay


Well you certanity lived up to your signature.

I take it that you have additional files in your filegroup, because that is exactly what you have done using that option


--------------------------------------------------------------------------------------
Recommended Articles on How to help us help you and
solve commonly asked questions

Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden
Managing Transaction Logs by Gail Shaw
How to post Performance problems by Gail Shaw
Help, my database is corrupt. Now what? by Gail Shaw
Post #799808
Posted Thursday, October 08, 2009 3:16 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, April 10, 2014 6:28 PM
Points: 1,199, Visits: 1,898
Thanks to write..

Hi Gilla Actually my servers are full of logs and in near future I have to make space on drive....


Thanks

Post #799815
Posted Thursday, October 08, 2009 3:16 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 @ 4:21 AM
Points: 41,507, Visits: 34,422
Silverfox (10/8/2009)
I take it that you have additional files in your filegroup, because that is exactly what you have done using that option


He's shrinking the log, so no filegroups. I hope there's a second log file



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 #799816
Posted Thursday, October 08, 2009 3:19 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 @ 4:21 AM
Points: 41,507, Visits: 34,422
guptaajay1985 (10/8/2009)
Hi Gilla Actually my servers are full of logs and in near future I have to make space on drive....


That didn't answer anything.

You're talking about transaction log files (.ldf)? How many log files does the DB have? How many data files? What sizes?
What recovery model? How often are you doing full backups? How often are you doing log backups?



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 #799818
Posted Thursday, October 08, 2009 3:19 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, April 10, 2014 6:28 PM
Points: 1,199, Visits: 1,898
I have searched it but I have not found any other log file.....

Hi silverfox ...But I have not found any other log file in whole computer...


Thanks

Post #799820
Posted Thursday, October 08, 2009 3:21 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, April 10, 2014 6:28 PM
Points: 1,199, Visits: 1,898
Dear Gila...

Thanx to write...
I know all but currently I was testing on a dummy server....


Thanks

Post #799821
Posted Thursday, October 08, 2009 3:22 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 @ 4:21 AM
Points: 41,507, Visits: 34,422
Can you answer my questions and explain exactly what you're trying to do and why.

Please read through this as well - Managing Transaction Logs



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 #799822
Posted Thursday, October 08, 2009 3:28 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, April 10, 2014 6:28 PM
Points: 1,199, Visits: 1,898
Dear Gila,

Thanx for special attention..

one transaction log file
size 11.6 GB (before) now 1MB
recovery mode full
daily backup at 9:00 pm


Thanks

Post #799824
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse