Monday, August 26, 2013

[MS SQL Server] The TEMPDB

[MS SQL Server] The TEMPDB


The TEMPDB

Posted: 25 Aug 2013 11:57 AM PDT

Dear All, I have run into a situation wherein some maintenance is required on the Cluster disk that hosts this TEMPDB. So iam having to temporarily move the files residing in there to elsewhere during this downtime. Once the physical disk maintenance is complete I would put back the files to where they were. What are the things to be considered and how can I go about it completing it smoothly :) ? One other question is doing such a maintenance on the sqls tempdb, will it affect the other system or other databases? Many thanks, Jai

Site Hand-Over Documentation

Posted: 25 Aug 2013 02:14 PM PDT

Hi all.I am new to the contracting world (coming from inhouse environments) and attempting to document a client site. I was wondering if there were standard documents that most DBAs use/like to have/demand when taking on a new customer/project.What am I looking for? A list of document titles/templates that describe the architecture/configuration/maintenance procedures/policies of a SQL Server site.I have my own ideas but I thought that I should ask about to see what others use.Thanks in anticipation.

No comments:

Post a Comment

Search This Blog