Main Menu

How to delete old data from msdb PDF Print E-mail

 

Every time we do a backup or restore process, it will have an entry in the MSDB system database. Hence the MSDB will grow eventually & it will make the backup check queries slow.

The tables it will be referring to are

BackupFile
BackupFileGroup
BackupMediaFamily
BackupMediaSet
BackupSet
RestoreFile
RestoreFileGroup
RestoreHistory

To avoid this situation we have to schedule we have to schedule maintenance plan to purge old data from MSDB. Also we can manually delete the old data using the following system stored procedures.

sp_delete_backuphistory
sp_delete_database_backuphistory

Syntax

Exec sp_delete_backuphistory '05/05/09'

The above query will delete all backup,restore entries prior to date 05/05/09.


Exec sp_delete_database_backuphistory 'pubs'

This above query will delete the entire backup restore entries history for pubs database.

Comments (45)
  • |204.152.211.xxx |2011-07-27 07:29:09 Jordan Retro 8  - air jordan 1 shoes
    world Jordan Retro 9famous Jordan shoes or boots created from modern australia raw supplies Jordan Retro 10obtainable in black, chestnut, grey, chocolate, rose, pink.simply butJordan Retro 11 that fashionable.Recently, my friend bought a pair of modern australia merino sheepskin Jordan Retro 12 from specialty shop, genuinely fantastic feeling, she couldn¡¯t wait any much more to wait me,Jordan Retro 13and recommend me to obtain one as well, needless to say I know much more aboutJordan Retro 14, I¡¯m Jordan shoes or boots fans, the income I get from Jordan Retro 15 countless,just pursuing checklist several principal income of Jordan Retro 16. help for Jordan shoes or boots selling with several years, in condition you however odd aboutAir Jordan 16.5, you need to regret no to own recognized Jordan shoes or boots before!Wearing snow boots action just abating and comfortable, Team Jordan Retro 17in accession alluring and pretty, suggestions regarding how to gather Jordan Retro 18 Auc...
    ReplyQuote
  • |205.209.140.xxx |2011-08-17 08:09:37 uggs sale  - uggs sale
    By all means, they look dangerously comfy,uggs sale, that I wouldn’t be surprised if you caught me accidentally walking down to belstaff jacket. Even so, I am feeling stress-fully torn between my belstaff jackets for comfort and their link to my Grandmother’s ugg canada. Surely, if I pop these on it doesn’t mean I’ve crossed the line between stylish and uggs sale? As long as Countryfile isn’t on that ugg canada.Perhaps it’s just my own irrational fear of picturing these slippers with ugg classic tall? If, however, these luxurious bailey button ugg were teamed with your favourite check pyjama trousers and an oversized t-shirt ugg bailey button, and accessorized with some bailey button uggs then I reckon we’d have an indoor-shoe winner.clw817
    ReplyQuote
  • |205.209.143.xxx |2011-08-24 06:24:08 ugg boots sale  - ugg boots sale
    Located in Canada,we provide you with best quality luxurious ugg boots sale. belstaff jackets are selling all around the globe. Choose from our belstaff jacket,and Lace Up boots as well as our enormously popular uggs canada. Kids and baby boots are also available, as well as slippers and scuffs and our uggs canada range and Desert boots. To complement our ugg boots canada we also offer top quality Pashmina shawls. Don't forget to visit our specials page and grab yourself a ugg classic tall boots!At ugg bailey button you will not only receive the best quality products, but highly competitive prices and excellent customer service. If you can't find what you are looking for or have questions on any of our bailey button uggs, please visit uggs bailey button or contact us for more information.clw824
    ReplyQuote
  • |205.209.140.xxx |2011-10-18 08:43:20 Moncler jacket womens  - Moncler jacket womens
    CCX
    Thank you for sharing the the fabulous pictures and idea to us. Fashion season in 2011,Ugg boots replica Ugg boots replica matches well with Moncler jackets,Ugg bailey button which is popular all over the world. Ugg bailey button many belt leather shoes and boots,Ugg roxy tall a sharper,Ugg classic cardy sexy have add.Moncler jacket womens Big breath jacket, full of luxurious elegant taste, whether you can control the got such big style, from the beginning to the end of the delicate, do not have lasting appeal,Moncler jackets Ugg roxy tall fashion of women is more and more high requirements, control the shoes, the most important is to should stand the test foot stronger, the unique with elegant back before one iota props up the shoes, the focus of the shiny silver also nots allow to let people ignored. Moncler jacket womens Women moncler coats lovely the ball ball adornment is very denounce happy event, whole dress up have a student's young and nifty feeling, acid a black pants ...
    ReplyQuote
  • |115.126.14.xxx |2011-10-29 03:11:12 christian louboutin sale  - christian louboutin sales
    Thank you for sharing the wonderful pictures and idea to us. Popular season in 2011, herve leger dress and christian louboutin sale you can find popular with high quality clothes and shoes, we can provide a lot of 2011 new style of the best herve leger dress shoes and the Christian Louboutin clothes. Herve leger replica with excellent quality and as an original copy same design because of its attention and sexy design style, it attracts many international customers, including the world's most beautiful and the most fashionable women, Hollywood movie star. Modern, Christian Louboutin on women standing is preferred. With more and more fine, more and more high, once in the christian louboutin sales, breast will be standing naturally, the arc of the hip will more tight become warped, on the vision to strengthen the feminine qualities, show the convex curve bending before, natural have feminine taste. In 2011, put on herve leger replica dress and christian louboutin high boots, 2010 tro...
    ReplyQuote
  • |66.197.219.xxx |2011-11-05 02:47:17 Anonymous
    Visitors to Nike Portland, which opened this morning at the corner of Southwest Fifth Avenue and Morrison Street, may notice the architectural details of the interior before they start checking out the merchandise.
    2011 fall and winter fashion available.
    cheap nike free
    nike air force 1
    cheap nike air force 1
    nike free
    Please come with me here to see In this beautiful world !
    ReplyQuote
  • |205.209.142.xxx |2011-11-05 07:31:16 Christian louboutin sneakers  - Christian louboutin sneakers
    Ccx
    My friends will also be glad to know this new styles, and I am going to email them.
    New designed Moncler jackets womens is on sale for this season. As for the long coat design is concerned,Moncler jackets mens diversity is already got the perfect show.Christian louboutin sneakers, besides have everybody again, long to familiar calf halfway style, there are actually very short boots canister to challenge the novel style, almost only encase foot and ankle, only coated to even out of style, to extend women for primary task, leg line, and the october-december quarter because of unprecedented popular skinny pants), Moncler down jackets is extremely rich in simple sense and not lack of delicate.Montblanc pens is we know the best,the company's brand of dragon of dedicated to With different characteristics, the coat is suitable for snow in city life.Christian louboutin ankle boots very skinny with long gaiters trousers together seamlessly, fashionable tide women not to be missed. In f...
    ReplyQuote
  • |205.209.143.xxx |2011-11-08 01:09:28 Jimmy choo sale  - Jimmy choo sale
    Ccx
    I am going to pass the new style to my best friends. They will definitely love them. . christian louboutin sneakers and Herve leger dress, the fire and Herve leger dress is popular all over the world. Women like the "bandage" as the sexy details, they use "Herve leger replica dress" bundle out of sexy figure concave and convex have send. Jimmy choo shoes glossy patent leather enhances the sleek, breezy design of a wonderfully versatile sandal set on a classic high heel.Don't do the most brilliant and also don't do the lowest. Jimmy choo salesparkling platform pump transforms the line of your leg with a slimming, lengthening effect.Herve leger v neck dress with its own language, confided women the curve of the gentle, sending out the mature female charm. Exciting news for shoe lovers: Jimmy choo Bridal Shoes just launched a bridal line! With styles for summer, winter, beach and city weddings,Don't just look good fashion but also a good wear to give you.Herve lege...
    ReplyQuote
  • |66.197.219.xxx |2011-12-10 06:13:25 Anonymous
    New Orleans general NFL Jerseys promises owners savings of perhaps a quarter billion dollars a year but largely leaves intact the soft discount shoes wholesale salary cap system that the players fought hard to maintain.Stern and Deputy Commissioner Adam Silver announced the deal during a press conference, putting an end to nearly two years of difficult negotiations that resulted in the second shortened season in NBA history. Owners also agreed to an cheap nba jerseys expanded cheap nike air max revenue sharing plan, and Stern called both agreements "a watershed moment" for the league. The plan, nike free which will begin in 2013-14, more than quadruples the revenue currently shared by teams, with soccer shoes Stern saying they could now receive in excess of 20 million and at least six teams could pay 50 million into the plan.A outdoor shoes person familiar wholesale nike shoes with the negotiations says the framework of a three-team trade is in place to send New Orleans Horn...
    ReplyQuote
  • |221.150.177.xxx |2011-12-16 03:18:10 rings online
    Please remember that vintage watches have survived for many decades by being treated Romance God created the brand since 1988,

    replica watchesthe company, registered in 102 countries around the world omega seamaster ladies

    watches,jewelry brand,watches onlinemerchandise exports to 70 countries, is a specialized manufacturer

    of watches and jewelry. Romance of God in 1998 to become a global brand, replica rolex
    hire famous Swiss designer Wolfgang Jonsson program development of brand identity company logos,tiffany jewelry

    uniform color. Romance God omega seamaster quartz watches Korea Co.,Tiffany Ltd. has become the leading

    companies in the industry, rings onlinethe reputation is well known South Korean brand abroad. God watches Co.

    Tiffany ringsLtd. has always been committed to technological innovation and excellence in quality romantic

    and fashion capture,jewellery shopfashion jewelry has become a world dedicated to business goals and

    tireless efforts.
    ReplyQuote
  • |66.79.164.xxx |2011-12-24 09:11:22 Christian Louboutin Ankle Boot  - Christian Louboutin Ankle Boots

    Ccx
    It is really nice of you to share the excellent shoes information to others.
    Christian Louboutin Pumps foot that one wipe enthusiastic red, no matter how plain clothes, they were unable to hide the hostess as fire the lively personality. Modern, Christian Louboutin High Boots for women is stand for beautiful. Heel becoming larger and more and more high, once in Christian Louboutin Bags , breast will natural standing, coxal radian will be more tightening become warped, on the vision strengthened the woman idiosyncratic, show lordosis of curved curve, natural after have woman flavour. Christian Louboutin Flats, perhaps no high-heeled shoes enchanting scenery, but designers have mastered the female people's psychology, now designed Christian Louboutin Ankle Boots , lovely and elegant, appropriate safety. When a woman loves Christian Louboutin Evening is really began to enjoy doing a woman's feelings, love Christian Louboutin Sneakers of woman, all louboutin evening shoes not neg...
    ReplyQuote
  • |69.46.92.xxx |2012-01-09 02:11:53 Anonymous
    As opposed to making use of its conventional louis vuitton speedy supplies, this season Louis Vuitton has released a brand new series-the Louis Vuitton Slightly Denim. Just as its name tells, the bag is slight in weight for the light denim it made use of cheap louis vuitton and will cheer you up inside the downturn economy with its easy but sophisticated color.Pretty much for every single woman, besides the outfits, handbags are really a further kind of important accessories in her wardrobes. Nowadays, handbags aren't restricted towards Tiffany and CO the standard function of holding every day essentials. Shopping for a Louis Vuitton monogrammed Vernis purse is an investment within your fashion louis vuitton artsy future. The LV and 4 pointed flower monogram are renowned world-wide Tiffany jewelry outlet. In truth, the Louis Vuitton brand name is one of the most pricey names within the globe, products notwithstanding.One thing that you simply need to normally keep in mind regarding ...
    ReplyQuote
  • |221.149.123.xxx |2012-02-08 06:12:03 Anonymous
    In a nod to Victoriana louis vuitton speedy 25, Zoe Saldana wore a charmingly dishabille design in shades of crimson by Louis Vuitton.One casualty from louis vuitton neverfull the sales slump was UK based supermarket giant, Tesco -- the world's third largest retailer -- which was forced to offer you a profit louis vuitton speedy 35 warning within the wake of a disappointing UK Christmas trading period. It saw a 2.3% fall of like for like louis vuitton artsy GM | PM sales on the previous year.Outside of Asia and Brazil, wealthy buyers are also reaching for their Louis Vuitton purses once again following louis vuitton artsy a number of years of downturn-induced caution, in accordance with louis vuitton luggage.Such figures are in contrast for the bleak atmosphere elsewhere inside the retail sector louis vuitton speedy 30. European Commission figures show that sales fell by 2.5% inside the eurozone amongst November 2010 and 2011, and by 1.3% across the European Union louis vuitton speedy.Inside a split decision, a three-judge panel of the 9th U.S. Circuit Court of Appeals discovered the state's Proposition 8 "works a meaningful harm to gays and lesbians" by denying their right to civil marriage i...
    ReplyQuote
  • |206.253.41.xxx |2012-02-22 06:02:43 tiffany rings
    Please remember that Tiffany and covintage watchestiffany ringshave tiffany circle pendansurvived for many decades by being treated Romance God created the brand since 1988, the company, registered in 102 countries around the world omega seamaster ladies watches,jewelry brand,merchandise exports to 70 countries, is a specialized manufacturer of watches and jewelry. Romance of God in 1998 to become a global brand,hire famous Swiss designer Wolfgang Jonsson program development of brand identity company logos,uniform color. Romance God omega seamaster quartz watches Korea Co., Ltd. has become the leading companies in the industry, the reputation is well known South Korean brand abroad. God watches Co.Ltd. has always been committed to technological innovation and excellence in quality romantic and fashion capture,fashion jewe
    ReplyQuote
Write comment
Your Contact Details:
Comment:
[b] [i] [u] [url] [quote] [code] [img]   
:D:angry::angry-red::evil::idea::love::x:no-comments::ooo::pirate::?::(
:sleep::););)):0
Security
Please input the anti-spam code that you can read in the image.
< Prev   Next >
 
Copyright 2009 SQL Server.in, Powered by Joomla!; Joomla templates by SG web hosting