• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 277
  • Last Modified:

SQL server standard procedures

Hello All,

I have to create standard procedural documents/templates for our SQL servers.

-SQL database backups and log backups (includes how to track and verify daily db backups)
-SQL server patching (procedure)
-Setup New SQL server for development/UAT etc ( create template to store information to setup new server which should include database, permissions, owner, approvals etc.)
-Replication (check records in sync)
-SQL daily checks (include backups, jobs disk space etc.)

If anybody have any templates or documents or any kind of procedures for any of these and would share it I would really appreciate it.

Thanks,

0
BrookK
Asked:
BrookK
  • 2
1 Solution
 
jogosCommented:
Isn't there a default report in SSRS that gives an overview?
0
 
BrookKAuthor Commented:
Thanks for the links. I will go through them.

Which report? Please share more details so I won't spend more time investigating this.

Thanks,
-B
0
 
BrookKAuthor Commented:
The link has someful information
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now