Re: advice about setting up a server

From: charly (kanari_at_yahoo.fr)
Date: 02/19/04 

Date: Thu, 19 Feb 2004 20:52:06 +0000

Ok thank you for your answer.
I think I'll stick to the following plan :
Machine A backups on B
databases on B backed up on A

Later, If I have some spare time, I'll look into evms

Many Thx for your input !!

Relevant Pages

  • Use of backups / log shipping in datawarehouse ETL
    ... plans and log shipping. ... propagating data from production system databases to a data warehouse. ... This includes taking full backups of the databases ... Is there some way of Keeping the existing plan for nightly full backups, ...
    (microsoft.public.sqlserver.server)
  • backups running twice
    ... our databases at midnight every night. ... we changed this plan to backup at 10PM instead of 12AM. ... The backups at 10PM were successful last night, and SQL Activity Monitor ...
    (microsoft.public.sqlserver.setup)
  • Re: Backing up transaction logs
    ... >>the sound of it you may have specified a single plan for ... You can't do log backups of master ... > databases (full backups ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Maintenance Plans and Atomic Backups of a Set of Databases
    ... Actually, the maintenance plans are still a valuable method of running backups, though you can also create scripts for them. ... Yes, the documentation indicates that STOPATMARK should work for you, provided that you update all 12 databases inside the same marked transaction. ... However, no matter when you decide to set the transaction marks, it is the restore databases that will make use of them. ...
    (microsoft.public.sqlserver.tools)
  • Re: Backup job reported as failed
    ... databases in MS SQL Server 2005. ... In the "Maintenance Plan" node of the log viewer: ... Every entry has a red X next to it. ...
    (microsoft.public.sqlserver.tools)