Checklist

Jun 24, 2008

Hello,
In my firm, they have a checklist they go through for each sql server machine. This is the checklist for each new sql server machine.

There are two pages of these checks i.e.
version
domain,
memory,
recovery model...
IS there a third party software out there for these kind of tasks?

Thanks

View 4 Replies


ADVERTISEMENT

Checklist

Apr 8, 1999

Hello everyone,

I want to document my MS SQL Servers 6.5 so I have all the information I need in case a crash happens. Has anyone or knows anyone where I can find/download a checklist with all the things I need to document.

Thanks,
Stef

View 1 Replies View Related

Daily Checklist Of DBA

Mar 19, 2008

Hello All,

What should i have to check as a DBA at every new day. Is any one having scripts for the checklist then please send me that scripts.

Thanks
Prashant Hirani

View 8 Replies View Related

Upgrade Checklist From 2000 To 2005

Mar 28, 2008

hi all,
i have written a small checklist for my upgrades of databases from 2000 to 2005 servers. I was hoping you can take a look and see if im missing something.

TIA

1.Create backup of 2000 Database to a file group
a.Full Backup
b.Overwrite Existing Media Set
c.To File with Extension .BAK
d.Locate backup on DEV @ X:SqlServer_DataMSSQL2K5BACKUP
e.Make sure Backup File Name has _for_2k5_migration.BAK at the end
2.Create Database on SQL Server 2005 System on DEV
a.MYSERVERDEVELOPMENT2K5
b.Data files go to : X:SqlServer_DataMSSQL2K5DATA
c.Log files go to : X:SqlServer_DataMSSQL2K5LOG
d.Set Compatibility to 80 (SQL SERVER 2000)
3.Restore Backup to 2005 From File
a.Options Tab – Check Overwrite existing database
b.Once Restore is completed set compatibility mode to 90 (Sql Server 2005)
4.Script all Logins to 2K5
a.Go into 2000 server Security -> Logins
b.Script as CREATE TO Clipboard
c.Open query on 2K5 DB
d.Paste and run (Database must be installed on 2K5 first)

i have not done anything about maintenece plans - is this okay as it is or am i forgetting / not knowing anything else!

View 1 Replies View Related

Checklist For Moving A Database From One Server To Another?

Jul 20, 2005

Hi all. I know that since you know nothing about my database it willbe a stretch to answer this - but does anyone have a boiler platechecklist for moving a database, dts packages, agent jobs, etc...fromone server to another? Maybe something that just says I should atleast do x,y,z.Also if anyone out there has any hard won experience/advice aboutgotchas when doing this I would love to hear it. We have outgrown aserver and are installing a new one this week that we need to moveover to.Thanks!

View 2 Replies View Related

SQL Server 2005 Security Checklist

Feb 27, 2007

Has anyone compiled a list of out of the box features to disable (like sql mail in 2000)? Or even just a general security checklist for 2005?

I'm looking for one similar to http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sp3sec04.mspx

View 1 Replies View Related

Checklist For Testing Cluster Once Databases Are Installed?

Apr 30, 2012

I am an oracle dba who has had to take on SQL Server DBA duties.I have configured the operating system and verified the cluster for a Windows 2008R2 Active / Passive Cluster
.
I am now going to install the SQL Server Instance and build my database on the first node. Do you know of a great link to a procedure that defines the steps in performing this phase of the installation?Also, do you know of a good link to a checklist for testing the sql cluster once the databases are installed?

View 2 Replies View Related

Data Warehousing :: Listing Out Checklist From DBA Perspective For BI Implementation Project

Apr 16, 2015

We are in Designing phase Data Modeling of PDW/APS Implementation Project.

I need making a checklist from a DBA perspective.

Like what are things ill be needing at a time of implementation/Deployment.

View 2 Replies View Related

SQL 2K Security Baseline Or Security Checklist

Jul 20, 2005

Is there anybody out there with a MS SQL 2K Security Baseline orSecurity Checklist. Where can I get one????Thanks in advanceDavid

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved