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
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
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
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!
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 RelatedHas 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
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?
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.
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