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 «««12345

Getting an error "Exception of type 'System.OutOfMemoryException' was thrown." during stored procedure execution Expand / Collapse
Author
Message
Posted Friday, September 13, 2013 6:33 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 8:15 AM
Points: 826, Visits: 2,664
pradeep.mohan (9/13/2013)
Yes, now i can able to restore via GUI...Many thanks.

but MSDB database size still 50GB how can i reduce the size after cleanup backup history table.

So what is the impact if am going to shrink the msdb data file why because log shipping is configure in this server.

Shrink while log shipping is fine.




The SQL Guy @ blogspot

@SeanPearceSQL

About Me
Post #1494558
Posted Friday, September 13, 2013 6:36 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Today @ 12:44 AM
Points: 91, Visits: 322
Thanks.

Pradeep
Post #1494560
Posted Tuesday, September 17, 2013 4:40 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Today @ 12:44 AM
Points: 91, Visits: 322
I shrink the MSDB data file but size is not reducing but i can able to shrink log file size also reduce.

Pradeep
Post #1495440
« Prev Topic | Next Topic »

Add to briefcase «««12345

Permissions Expand / Collapse