Veritas-bu

[Veritas-bu] SQL 2000 Restore

2003-09-24 10:33:38
Subject: [Veritas-bu] SQL 2000 Restore
From: jdezan AT diveo.net DOT br (Julio Duarte de Assis Dezan)
Date: Wed, 24 Sep 2003 11:33:38 -0300
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C382A8.D7C7AD90
Content-Type: text/plain;
        charset="iso-8859-1"

I need to restore the master database from a backup using the Netbackup SQL
Agent. I have the Master server veersion 3.4.1 running in a Windows 2000.
I tried a directly restore and saw in the logs that the database need to be
in single user mode. I tried to put the database in single user mode and
stop all the services that access the database and get a log informing that
the user cannot connect with the specified DSN cause the database is in
single user mode.
Is there a step by step document teaching how to restore the master database
with NBU SQL agent?

Tks,

Julio 

------_=_NextPart_001_01C382A8.D7C7AD90
Content-Type: text/html;
        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2653.12">
<TITLE>SQL 2000 Restore</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=3D2 FACE=3D"Arial">I need to restore the master database =
from a backup using the Netbackup SQL Agent. I have the Master server =
veersion 3.4.1 running in a Windows 2000.</FONT></P>

<P><FONT SIZE=3D2 FACE=3D"Arial">I tried a directly restore and saw in =
the logs that the database need to be in single user mode. I tried to =
put the database in single user mode and stop all the services that =
access the database and get a log informing that the user cannot =
connect with the specified DSN cause the database is in single user =
mode.</FONT></P>

<P><FONT SIZE=3D2 FACE=3D"Arial">Is there a step by step document =
teaching how to restore the master database with NBU SQL agent?</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">Tks,</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">Julio </FONT>
</P>

</BODY>
</HTML>
------_=_NextPart_001_01C382A8.D7C7AD90--

<Prev in Thread] Current Thread [Next in Thread>
  • [Veritas-bu] SQL 2000 Restore, Julio Duarte de Assis Dezan <=