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


Space Issue in C drive


Space Issue in C drive

Author
Message
Honny
Honny
SSC Rookie
SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)

Group: General Forum Members
Points: 38 Visits: 107
Hi ,

Please need help urgently ..

We are using SQL server 2012 version and as usually we are deploying ssis Packages in Integration services Catalog by Creating SSISDB Catalog and placed our package in separate folders for each package and
when we are Scheduling the Package for every 2 minutes the transaction log files are storing in C.Drive in respective path C:\Program Files\Microsoft SQL Server\MSSQL11.InstanceName\MSSQL\DATA

Because of that transaction Log files created by SSISDB the C Drive space was reducing simultaneously and after some time packages are crashing.

so can you help me in this issue as soon as possible..

Because of this issue we are not able to do any work .....
John Mitchell-245523
John Mitchell-245523
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14658 Visits: 15980
What is the recovery mode of your database? Do you have transaction log backups set up?

John
Koen Verbeeck
Koen Verbeeck
One Orange Chip
One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)

Group: General Forum Members
Points: 28059 Visits: 13268
And why o why do you keep your log files on your C drive?
That is waiting for disaster to strike.


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
twin.devil
twin.devil
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2441 Visits: 2675
Koen Verbeeck (12/17/2013)
And why o why do you keep your log files on your C drive?
That is waiting for disaster to strike.

++1, you need to move your files

you can do the following:

Detach the database, move the files, reattach the database.

OR

Use the ALTER DATABASE ... ALTER FILE to change the metadata. Take the database offline, move the files, bring the DB back online.

Do it hurry and do not make database on C Drive from now on :-)
Honny
Honny
SSC Rookie
SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)

Group: General Forum Members
Points: 38 Visits: 107
iam using recovery Mode is simple and i have done shrinking also for databases i am using also but no use..

if we try following query i am able to see
DBCC SQLPERF (LOGSPACE)


master 0.7421875 56.44737 0
tempdb 1.492188 54.54843 0
model 0.4921875 89.88095 0
msdb 0.9921875 60.28543 0
ReportServer$MHBCPACCHAD 6.867188 19.0273 0
ReportServer$MHBCPACCHADTempDB 1.054688 69.39815 0
MHBCPACCHAD 0.9921875 47.78543 0
MHBCPACCHAD_Testing 0.9921875 66.97835 0
SSISDB 8014.742 93.30867 0
Honny
Honny
SSC Rookie
SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)

Group: General Forum Members
Points: 38 Visits: 107
Databases we have created in D Drive not in C Drive and we have problem at ssis DB Catalog folder and main problem is transaction log files truncation..
how we clean up transaction log files... which is already stored in the C.drive please help as soon as possible..
Koen Verbeeck
Koen Verbeeck
One Orange Chip
One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)

Group: General Forum Members
Points: 28059 Visits: 13268
Honny (12/17/2013)
Databases we have created in D Drive not in C Drive
<snip>
which is already stored in the C.drive


Ehrm... why would you create your databases on the D drive, but store your log files on the C drive?

Anyway, since you are using the simple recovery model you cannot take a log backup.
So you can either

* shrink the log file (not really recommended)
* allocate more space on the C drive (probably a temporary solution)
* move the log files to a bigger disk (the way to go)

Another question: why is the "ssisdb" creating log files?


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
Honny
Honny
SSC Rookie
SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)

Group: General Forum Members
Points: 38 Visits: 107
PLEASE SHARE YOUR NUMBER PLEASE SO THAT I CAN EXPLAIN YOU CLEARLY WHAT THE ISSUE I WAS FACING PLZ PLEASE PLEASE

iTS URGENT ITS URGENT
ARE YOU CAN CONTACT ME ON 9582809916
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