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_01C2ABAA.37473A00
Content-Type: text/plain;
charset="iso-8859-1"
Rene,
I am backing up 20+ SQL 2k servers on W2k Advanced Server. On the OS or
file system backups (FS), I configure excludes by opening Admin Console,
then expand Host Properties and click on Clients. Once the Client screen
appears, click on the client name. In the Client Properties window, click
on Exclude. If am backing up the drive where the SQL files reside, I
exclude with *.mdf & *.ldf. That way the SQL db files are ignored.
As far as the SQL files, you should find files names master,msdb, pubs,
model and in other database files in the folder you noted. In some
installations, the database files are stored on there own drives. They
would not appear in the folder named below.
Good Luck!!
Rick Morris
IGT - SAP Basis Administrator
775-448-7293
-----Original Message-----
From: rene_casalme AT baxter DOT com [mailto:rene_casalme AT baxter DOT com]
Sent: Monday, December 23, 2002 16:42 PM
To: veritas-bu AT mailman.eng.auburn DOT edu;
veritas-bu-admin AT mailman.eng.auburn DOT edu
Subject: [Veritas-bu] SQL-Server backup
Know Oracle but new to SQL Server.
I was planning on having two policies to backup this server. The first one
is for the OS and the second is for the SQL-Server database. Looking at the
manual, I couldn't find any reference to an exclude list for Windows 2000
policy. Normally, in Solaris, I would backup the system minus the Oracle
datafiles. Is there a way to exclude backup of the SQL Server files during
the system backup? It appears the SQL Server was installed in D:\Microsoft
SQL Server\MSSQL. Are all the relevant SQL Server files contained in this
directory?
Any input or alternative approach appreciated?
Regards,
Rene
------_=_NextPart_001_01C2ABAA.37473A00
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2716.2200" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=605245023-24122002><FONT face=Arial color=#0000ff
size=2>Rene,</FONT></SPAN></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=605245023-24122002>I am backing up 20+ SQL 2k servers on W2k
Advanced Server. On the OS or file system backups (FS), I
configure excludes by opening Admin Console, then
expand </SPAN>H<SPAN
class=605245023-24122002>ost Properties and click on Clients. Once the
Client screen appears, click on the client</SPAN><SPAN
class=605245023-24122002>
name. </SPAN><SPAN class=605245023-24122002> In the Client Properties
window, click on Exclude. If am backing up the drive where the SQL files
reside, I exclude with *.mdf & *.ldf. That way the SQL db files
are ignored. </SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=605245023-24122002>As far as the SQL files, you should find files names
master,msdb, pubs, model and in other database files in the folder you noted.
In
some installations, the database files are stored on there own drives.
They would not appear in the folder named
below. </SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=605245023-24122002></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=605245023-24122002></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=605245023-24122002>Good Luck!!</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=605245023-24122002></SPAN></FONT></FONT></FONT><B><FONT
face="MS Sans Serif">Rick Morris</FONT></B> <BR><B><FONT face="MS Sans Serif"
color=#008080 size=2>IGT - SAP Basis Administrator</FONT></B> <BR><B><FONT
face="MS Sans Serif" color=#008080 size=2>775-448-7293</FONT></B> </DIV>
<BLOCKQUOTE>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> rene_casalme AT baxter DOT
com
[mailto:rene_casalme AT baxter DOT com]<BR><B>Sent:</B> Monday, December 23,
2002
16:42 PM<BR><B>To:</B> veritas-bu AT mailman.eng.auburn DOT edu;
veritas-bu-admin AT mailman.eng.auburn DOT edu<BR><B>Subject:</B>
[Veritas-bu]
SQL-Server backup<BR><BR></FONT></DIV><BR><FONT face=sans-serif size=2>Know
Oracle but new to SQL Server.</FONT> <BR><BR><FONT face=sans-serif size=2>I
was planning on having two policies to backup this server. The first
one
is for the OS and the second is for the SQL-Server database. Looking at
the manual, I couldn't find any reference to an exclude list for Windows 2000
policy. Normally, in Solaris, I would backup the system minus the
Oracle
datafiles. Is there a way to exclude backup of the SQL Server files
during the system backup? It appears the SQL Server was installed in
D:\Microsoft SQL Server\MSSQL. Are all the relevant SQL Server files
contained in this directory?</FONT> <BR><BR><FONT face=sans-serif size=2>Any
input or alternative approach appreciated?</FONT> <BR><BR><FONT
face=sans-serif size=2>Regards,</FONT> <BR><BR><FONT face=sans-serif
size=2>Rene</FONT> <BR></BLOCKQUOTE></BODY></HTML>
------_=_NextPart_001_01C2ABAA.37473A00--
|
