|
I have a SQL 2008 database, run on 64 bit Win2008 Server. I created a pretty simple powershell script that automates a bunch of tasks. I would like this script to run as part of our maintenance plan. Anyone have any tips, or another suggested way to schedule...
Started by aSkywalker on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at serverfault):
Powershell+script
You can run your PowerShell script within SQL Server 2008 Agent (SQL Server's job.
|
|
What are reasons to have a site 'down for maintenance'? I seen a few go down with a msg up. I seen others that are never down for maintenance. What are reasons a site may be down? and what can i do (if possible) to not have a site go down (readonly) for...
Started by acidzombie24 on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at serverfault):
Implementing changes to infrastructure....
Valid reasons for scheduled downtime may include:
hardware or OS maintenance, eg patching or upgrades Running a cold backup Running some sort of daily maintenance job to keep things going smoothly.
|
|
I've created a couple of maintenance plans on our Sql Server 2008 databases that perform back-ups (full and differential) to run overnight, but they keep failing with a message saying the database is currently in use.
We typically have little to no traffic...
Started by michaeldelorenzo on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Are there other steps in the maintenance plan that could be causing this? Have you set up the reporting/logging options of the maintenance plan to write to a log file? That might give a little more.
|
Ask your Facebook Friends
|
What is the thing that irritates you while doing maintenance coding?
Can you point out some points for easier maintenance for me and my fellow programmers?
Started by JMSA on
, 46 posts
by 45 people.
Answer Snippets (Read the full thread at stackoverflow):
Concentrate your maintenance on clarity and correctness: Use smart pointers here, make this a class maintenance for me and my fellow....
How about maintenance coding itself?
But seriously, my biggest pet peeve is when i refactor.
|
|
Currently, if I want to output a SQL script for a table in my database, in Management Studio, I can right click and output a create script.
Is there an equivalent to output an SQL script for a database's maintenance plan?#
Edit
The company I work for ...
Started by Lord Future on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
You can then right click on the plan and select import or export
I don't think you can do that with Maintenance Plans, because those are DTS packages, well now could add maintenance plans, ....
Packages>MSDB>Maintenance Plans.
|
|
I need to setup a maintenance page for a website I'm running, e.g. for display when I'm performing site maintenance (scheduled downtime) or if something really breaks and I need to put up a holding page.
Is there anything special I need to do to ensure...
Started by DEfusion on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
Another approach would be to not link the maintenance page from any other page.
To come back.
|
|
What scheduled maintenance, tasks or jobs should be performed on Exchange Server and how often?
Started by Marko Carter on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at serverfault):
Everything else is ....
As such, you should be doing regular online backups.
I've also seen E2K3 servers run for years (with acceptable are going to pile up until a full or incremental online backup is run.
Is on DASD and not a SAN volume).
|
|
Hello,
I'm having a problem with a maintenance plan in SQL Server 2005. It's a very basic maintenance plan - it has one 'Execute T-SQL Statement Task' which simply inserts a row into a table.
When I execute the maintenance plan the T-SQL statement is ...
Started by Gavin on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at serverfault):
When I create the ....
When I create the Maintenance Plan on the server (through Terminal Services), it runs successfully.
Of warnings.)
If the actual SQL being run isn't dynamic, run it manually in a query window and check.
|
|
What are the best practices for optimal database maintenance?
is updating statistics necessary? (i think statistic update is on by default) how about reorganize indexes or just rebuild them? shrink database? integrity check?
How often do you run them?...
Started by Peter on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at serverfault):
•Have a regular process in place to take full database backups, plus workload and the performance issues, you may... .
This technet magazine article Top Tips for Effective Database Maintenance (and follow up podcast process to run DBCC CHECKDB.
|
|
What is Index Maintenance and how do I do it? How frequently do I have to do it? What are the benefits? This is related to a transaction table which is subject to frequently modifications; all DML operations will be run on that table.
Started by rmdussa on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
One way to do index maintenance....
Marc
to SQL Server that I'm not aware of, but:
Index maintenance would be a process that makes an index perform better.
Every night and clean up your indices.
maintenance plans which can run e.g.
|
