Hi, Here is an export of our sql 2005 maintenance plan history Date,Source,Severity,Plan Name,SubPlan Name,Task Name,Duration 06/07/2009 05:08:29,,Unknown,Weekly optimisation,Subplan_1,,05:08:25 06/07/2009 05:07:41,,Unknown,,,Shrink Database Task (localhost),00:00:48 06/07/2009 04:50:40,,Unknown,,,Rebuild Index Task (localhost),00:16:4...
Hello everyone, I am using SQL Server 2008 Enterprise version. I want to know if I do not explicitly set any maintenance jobs, are there any default maintenance jobs SQL Server will perform (like backup? rebuild index? truncate transaction log?)? Where to find the current maintenance jobs? thanks in advance, George ...
I'd like to clarify what the optimal maintenance plan set up is for the ASPState database that is used by ASP.Net SQL Server session state. The standard user database maintenance plan doesn't seem suitable. I'll never need to do a point-in-time restore of session data so it seems pointless to back up the database and transaction log fi...
Hello, We have a weekly maintenance plan to shrink all user databases and rebuild their indexes. This has working fine until we created a read-only database, now each time the plan runs it fails when it starts processing this database due to its read only state. As far as I can see we have two options remove the read only flag from th...
I'm looking for a way to periodically (e.g. weekly) run some SQL statements in a database to delete old data. As far as I can see, there are (at least) two ways to do this: using a "Maintenance Plan" and a "Execute T-SQL Statement Task" using an "SQL Server Agent Job" and specify the statements in a "Step" of that job My question is:...
Just got back from a client that asked to have an early termination clause added into a proposed maintenance contract. The contract is to be for a full year with option to renew. The client may pay monthly or all upfront. I'm wondering what is a good early termination fee assuming I should have one? No fee Fixed fee 2-4 months of month...
What are typical cache appliance maintenance tasks and schedule for same? ...
I am trying to do some basic maintenance on a sql server 2005 database. It's fairly small (10gb in size, 50 tables or so). I am first doing the following on all tables: update statistics [table name] with fullscan followed by reindexing all tables. DBCC REINDEX ([table name], ...) Is this correct? Is the sequence right? Do I ne...
We moved from Visual Source Safe to Team Foundation Server. Can I sync. TFS source control to Visual Source Safe? I would like to keep a backup of Team Foundation Server source control in Visual Source Safe. Just to have a backup server ready in case the Team Foundation Server rot out and we can quickly shift back to Visual Source Safe s...
We all know that writing quality, well-factored code is an asset for code maintenance, ease of bug-fixing, and development of new features, but I would like to approach the subject from a different angle. If a piece of software is written well enough that it solves the client's problem(s) perfectly for their workflow, what is their ince...
In the spirit of this question I wanted to have a sense of what is the proportion of time split between fixing bugs and implementing new features. If possible try to give an estimate for the product as a whole as opposed to individual developer stats and try to make an average over the course of a typical year. Do provide a general des...
Hi All, I have a maintenance plan that looks like this... Client 1 Import Data (Success) -> Process Data (Success) -> Post Process (Completion) -> Next Client Client 2 Import Data (Success) -> Process Data (Success) -> Post Process (Completion) -> Next Client Client N ... Import Data and Process Data are calling jobs and Post Process...
I created some Maintenance Plans in SQL Server 2008 without using the wizard (i.e. right-click on Maintenance Plans and select New Maintenance Plan...). When created that way, there is no option to specify the location for the Maintenance Plan Action Report. It is by default placed in the Log subfolder of the Program Files folder for tha...
I have an extensive maintenence plan on one sql server 2008 instance that I wish to move to 4 other instances. What is the best way to do this other than rebuilding it on each server? Thanks ...
DBCC ShrinkDatabase() DBCC ShrinkFile() Do I need to run both DBCC commands in order to shrink the database? What is the difference between these two above? ...
I have a scheduled Check Database Intergrity maintenance plan in sql agent. Every time it completes, i get an email and it has always succeded until now. This time the status in the email is "Failed". I have tried to excute the job manually in management studio and again it failes. I now want to investigate and find out why and get issue...
I used the SQL Server Maintenance wizard (along with a book) to generate both Full and Differentail backups. The Full backup runs on Monday morning and the Differentials run Tuesday through Saturday. The Full backup runs fine and generates the following email report... Microsoft(R) Server Maintenance Utility (Unicode) Version 10.0.2531 ...
I've set up a maintenance plan in instance #1 of SQL Server 2008. In theory, it will connect to instance #2 and back up those databases to the hard drive of instance #1. I have: Created a login on instance #2 Given that login the correct permissions needed to back-up a database (I tested it) Created a working connection in the mainte...