Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 324
  • Last Modified:

SQL server backup Document/White Paper

Hi All,
I have number of SQL 2005/2008 databases to manage here. I am new to SQL server so I am looking for a white paper or a backup solution from an expert.

I need to address :
1)  How to create a centralised backup environment consisting of hundreds of SQL databases? I should able to schedule backups from this console.
2) How to monitor/report failed backups every night?
3) What kind of compression, encryption technologies are available
4) Also a restore from one server to another should be possible


Many Thanks
0
crazywolf2010
Asked:
crazywolf2010
  • 3
  • 2
2 Solutions
 
Ephraim WangoyaCommented:

Here is a quick overview
http://msdn.microsoft.com/en-us/library/ms175477.aspx

Install SSMS (http://www.microsoft.com/download/en/details.aspx?id=22985)
Create maintenance plans for backups with verify (best verification is to restore random databases)
Setup notification through dbmail
When setting up the backups, you can choose to have compression, there is no encryption with the native method
0
 
jogosCommented:
Strategy  to stick with MS
http://msdn.microsoft.com/en-us/library/ms191239.aspx
or http://help.webcontrolcenter.com/KB/a1020/sql-backup-plan-for-mssql-2005-2008.aspx
mind the recovery model so a transaction log backup could be needed

Many backup programs do have oportunity to backup up databases also but be sure they realy execute the BACKUP statement and do not a worthless file backup.
0
 
crazywolf2010Author Commented:
Hi There,
Is there centralised backup system which could be used to backup hundreds of SQL serer databases?
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
jogosCommented:
With a maintenance-plan you can backup all databases of the same instance in action.  
0
 
crazywolf2010Author Commented:
OK I got that but how do you schedule at say 100 remote SQL servers and monitor success/failure/space usage of nightly backup?

Thanks
0
 
jogosCommented:
//simple-talk.com/sql/backup-and-recovery/centralized-management-tips-for-managing-backups-on-multiple-servers/
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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