tag:blogger.com,1999:blog-6806992453823338600.post5692020113487663655..comments2023-05-18T11:36:19.318-04:00Comments on SQL Server Newbie: HOW TO: Import/Export SQL Server Maintenance PlanJerry Hunghttp://www.blogger.com/profile/00173468802063778170noreply@blogger.comBlogger11125tag:blogger.com,1999:blog-6806992453823338600.post-8680977300012166182015-04-21T01:55:38.565-04:002015-04-21T01:55:38.565-04:00serverbuddies provides Quality remote server mana...serverbuddies provides Quality remote server management including troubleshooting, Server Management, Plesk Suppor, Server Maintenance, Server Monitoring, Server Troubleshooting and support for a large variety of customers at affordable rates. Here are option for Server Management, <a href="http://www.serverbuddies.com/" rel="nofollow">Server Maintenance</a>, Server Monitoring, Server Troubleshooting, Server Optimization, Plesk Suppo, Linux Support, cPanel Support and Plesk Support.<br />.........<br />elson cadehttps://www.blogger.com/profile/04601989980404314891noreply@blogger.comtag:blogger.com,1999:blog-6806992453823338600.post-3738748446892145662015-02-25T05:13:20.614-05:002015-02-25T05:13:20.614-05:00Awesome it works "GUI"Awesome it works "GUI"Ads for local communityhttps://www.blogger.com/profile/18271954270511754969noreply@blogger.comtag:blogger.com,1999:blog-6806992453823338600.post-61275772901402560802015-01-31T00:48:50.694-05:002015-01-31T00:48:50.694-05:00Hello,
A SQL maintenance plan for rebuilding index...Hello,<br />A SQL maintenance plan for rebuilding indexes and setting the index free space percentage to 10% within the Symantec/Arellia databases should be scheduled to run at least monthly (preferably weekly). This maintenance plan should also be configured to update column statistics (index statistics are updated during the index rebuild process).<a href="https://www.ibremarketing.com/" rel="nofollow">Server Maintenance</a> fitzjames41@gmail.comhttps://www.blogger.com/profile/00909179365697884199noreply@blogger.comtag:blogger.com,1999:blog-6806992453823338600.post-25745268359208432372012-06-07T10:08:03.279-04:002012-06-07T10:08:03.279-04:00Have you seen and used Ola Hallengren's award ...Have you seen and used Ola Hallengren's award winning solution?<br />I use it across 18 Servers and it works well for us. Offcourse, test it on some Development Server in your environment before you roll out. You can obtain it from: http://ola.hallengren.com/downloads.html<br />The MaintenanceSolution.sql script contains and creates all the Jobs. I modified it slightly for our environment, not to create the Backup Jobs, since I have already put in place our own custom backup solution.Anonymoushttps://www.blogger.com/profile/05704763080016773458noreply@blogger.comtag:blogger.com,1999:blog-6806992453823338600.post-47736505341860938002010-11-05T15:03:16.565-04:002010-11-05T15:03:16.565-04:00Ha, even myself don't use Import/Export as I j...Ha, even myself don't use Import/Export as I just manually create a new MP with the GUI<br /><br />I couldn't recall why I needed to export or posted this article<br /><br />@anthonyx26 - I guesst trial and error! no harm in inserting when you can delete it easilyJerry Hunghttps://www.blogger.com/profile/00173468802063778170noreply@blogger.comtag:blogger.com,1999:blog-6806992453823338600.post-57406250041806985392010-11-04T10:14:36.652-04:002010-11-04T10:14:36.652-04:00@RobK...thx for tip on new table name.
Ok...so I ...@RobK...thx for tip on new table name.<br /><br />Ok...so I ran query and it returns, amongst a few other records, the maintenance plan I seek to export to another SQL Server. So do I now just need to insert that value into the other server? As in:<br /><br />INSERT INTO sysssispackages (packagedata)<br />VALUES ('<DTS:Executable...')<br /><br />It seems like I will probably first need to modify the packagedata value to fit the params of the new server (chiefly, the server name). <br /><br />Then I guess it might be wise to manually create the maintenance plan (so SS creates all the IDs etc), with the same name, using SSMS. Then instead of the INSERT, do an UPDATE query with the new packagedata value.<br /><br />Sound about right? Or should I skip the step to create the MP manually? And if so, has anyone developed an INSERT that takes care of adding the required IDs as well?<br /><br />- anthonyx26Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6806992453823338600.post-43792663574088997482010-10-29T14:09:24.476-04:002010-10-29T14:09:24.476-04:00In SQL 2008 SP1 you may need to use sysssispackage...In SQL 2008 SP1 you may need to use sysssispackages table instead.<br /><br />Thanks,<br /><br />Rob KosteckiAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-6806992453823338600.post-17501915420414464522010-09-16T16:19:58.994-04:002010-09-16T16:19:58.994-04:002008 doesn't offer a "Package Placement&q...2008 doesn't offer a "Package Placement"....only Package Path which won't let you use an unc or other tree path....only existing sql folders.DJKhttps://www.blogger.com/profile/11077813900350300205noreply@blogger.comtag:blogger.com,1999:blog-6806992453823338600.post-31220298418720773092010-09-14T20:53:23.323-04:002010-09-14T20:53:23.323-04:00it seems like "the harder script way" is...it seems like "the harder script way" is not finished. what do you need to do after the select?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6806992453823338600.post-89247661479005553152010-07-06T12:01:41.833-04:002010-07-06T12:01:41.833-04:00dont you have to edit the connection and stuff whe...dont you have to edit the connection and stuff when importing into the new sql server machine?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6806992453823338600.post-22188869320702712642010-06-15T10:41:32.088-04:002010-06-15T10:41:32.088-04:00haha, can't stop laughing at how hard the hard...haha, can't stop laughing at how hard the harder way is :)Anonymousnoreply@blogger.com