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

While taking backup of MSDB database, in report log it is showing shortage of space. actually we are having 60+ Gb free space available on that drive. Expand / Collapse
Author
Message
Posted Wednesday, July 1, 2009 8:57 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, July 13, 2011 6:41 PM
Points: 7, Visits: 95
While taking backup of MSDB database, in report log it is showing shortage of space. actually we are having 60+ Gb free space available on that drive.

Please resolve the same ASAP.
Post #745479
Posted Wednesday, July 1, 2009 2:16 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, September 24, 2013 2:59 AM
Points: 174, Visits: 336
What about your other drives?
Post #745745
Posted Wednesday, July 1, 2009 4:20 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 12:25 AM
Points: 20,795, Visits: 32,710
goparaju.chandu (7/1/2009)
While taking backup of MSDB database, in report log it is showing shortage of space. actually we are having 60+ Gb free space available on that drive.

Please resolve the same ASAP.


Sorry??

If you want help, try asking. We need to see the actual error message if you want any kind of help, can't do anything based off what you have posted.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #745833
Posted Wednesday, July 1, 2009 5:03 PM


SSC Eights!

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

Group: General Forum Members
Last Login: Yesterday @ 3:31 PM
Points: 865, Visits: 7,452
How big is your MSDB database? Are you sure it's the MSDB backup that is causing the out-of-space condition.

Without more information, my response to a demand for an ASAP resolution would have to be:

Reply hazy, try again later.




And then again, I might be wrong ...
David Webb
Post #745862
Posted Wednesday, July 1, 2009 5:17 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 12:25 AM
Points: 20,795, Visits: 32,710
Actually, I keep checking my calendar and I can't find ASAP. I can find Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, and Sunday; but no ASAP.




Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #745873
Posted Thursday, July 2, 2009 7:34 AM


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Yesterday @ 3:49 PM
Points: 1,469, Visits: 8,351
Lynn Pettis (7/1/2009)
Actually, I keep checking my calendar and I can't find ASAP. I can find Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, and Sunday; but no ASAP.



Lynn, are you having trouble with the English language?

I believe the OP was asking the user "ASAP" to resolve the problem.




Alvin Ramard
Memphis PASS Chapter

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.
Post #746262
Posted Thursday, July 2, 2009 7:52 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 9:19 AM
Points: 1,307, Visits: 4,508
Lynn Pettis (7/1/2009)
Actually, I keep checking my calendar and I can't find ASAP. I can find Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, and Sunday; but no ASAP.



Keep looking, it's got to be there somewhere.
When you find it, take the day off, because there will be a lot of systems going live that day.



Post #746283
Posted Thursday, July 2, 2009 8:41 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 24, 2014 7:42 AM
Points: 185, Visits: 96
look for more information

1. size of msdb
2. recovery model of msdb
3. space available on the drive where you are taking backup...
4. Error message.

Once you have all in place, probably you should have the solution as well...

Good luck
Post #746326
Posted Thursday, July 2, 2009 9:47 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 12:25 AM
Points: 20,795, Visits: 32,710
Ian Scarlett (7/2/2009)
Lynn Pettis (7/1/2009)
Actually, I keep checking my calendar and I can't find ASAP. I can find Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, and Sunday; but no ASAP.



Keep looking, it's got to be there somewhere.
When you find it, take the day off, because there will be a lot of systems going live that day.


<< Apologies to The Thread >>

That may be when SkyNet rises!



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #746403
Posted Thursday, July 2, 2009 10:10 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 1:53 AM
Points: 35,540, Visits: 32,123
Ian Scarlett (7/2/2009)
Lynn Pettis (7/1/2009)
Actually, I keep checking my calendar and I can't find ASAP. I can find Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, and Sunday; but no ASAP.



Keep looking, it's got to be there somewhere.
When you find it, take the day off, because there will be a lot of systems going live that day.


Ahp... ASAP can't happen on Tuesdays.


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #746764
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse