| Author |
SQL instance question.
|
|
|
| First of all I am a newbie at understanding SQL so please bare with me.
I am not running SQL but I am running a program on a Server that creates
an SQL instance for it to use. The program name is LANDesk. The OS is
Server 2003.
I use Veritas 10 for backups. In Veritas I have a selection to backup the
database(s) but there is no selection for backing up the engine itself and
I verified that with Veritas's tech support.
Question:
How do I backup the SQL database engine/service so that I can restore them
in the event of a server OS reload?
Thanks in advance.
| |
| Jerry Spivey 2005-09-29, 11:23 am |
| Greg,
I think you're refering to the system databases in SQL Server. These would
include primarily the Master system database and the MSDB system database.
Both of which should be backed up whenever changes occur that affect them
(daily would be appropriate).
Veritas also includes an Intelligent Disaster Recovery (IDR) feature that
might help with Windows and the SQL Server installation.
HTH
Jerry
"Greg" <gregkh@hotmail.com> wrote in message
news:4DE65D74-4C66-45FC-A5B4- 2E35DE242939@microso
ft.com...
> First of all I am a newbie at understanding SQL so please bare with me.
>
> I am not running SQL but I am running a program on a Server that creates
> an SQL instance for it to use. The program name is LANDesk. The OS is
> Server 2003.
>
> I use Veritas 10 for backups. In Veritas I have a selection to backup the
> database(s) but there is no selection for backing up the engine itself and
> I verified that with Veritas's tech support.
>
> Question:
> How do I backup the SQL database engine/service so that I can restore them
> in the event of a server OS reload?
>
> Thanks in advance.
| |
|
| What do I need to backup and restore to recreate the MSDE if a full server
restore is needed?
"Jerry Spivey" wrote:
> Greg,
>
> I think you're refering to the system databases in SQL Server. These would
> include primarily the Master system database and the MSDB system database.
> Both of which should be backed up whenever changes occur that affect them
> (daily would be appropriate).
>
> Veritas also includes an Intelligent Disaster Recovery (IDR) feature that
> might help with Windows and the SQL Server installation.
>
> HTH
>
> Jerry
> "Greg" <gregkh@hotmail.com> wrote in message
> news:4DE65D74-4C66-45FC-A5B4- 2E35DE242939@microso
ft.com...
>
>
>
| |
| Hari Prasad 2005-09-29, 8:23 pm |
| Hi,
MSDB stores the Backup and Restore history, Alerts, operators, Tasks,
maintenance plans.... So if you do a full database
backup once and do a transaction log backup every 2 hours should be fine.
During the crash, you can restore the MSDB full database backup follwed by
the restore of subsequent transaction log backups.
Thanks
hari
SQL Server MVP
"Greg" <gregkh@hotmail.com> wrote in message
news:8C9EEDC9-7CEA-428D-8F0D- 9490FC32977E@microso
ft.com...[color=darkred]
> What do I need to backup and restore to recreate the MSDE if a full server
> restore is needed?
>
> "Jerry Spivey" wrote:
>
|
|
|
|