New to MS SQL 2000

How do I backup databases, onto Veritas Backup? In the Enterprise Edition if
I expand the database server I could select all task, backup database and
select the destination.
"OSA" <OSA@.discussions.microsoft.com> wrote in message
news:58C5D3AA-D2FC-419E-B560-DD5703546B5A@.microsoft.com...
> How do I backup databases, onto Veritas Backup? In the Enterprise Edition
if
> I expand the database server I could select all task, backup database and
> select the destination.
If you've got the Veritas netbackup SQL Server agent, you can configure
netback to capture all relevant databases. If not, you can use the SQL
Server backup database task wizard to backup your databases, then use
netbackup to backup these files.
Steve

New Publication

Hi,
I'm trying to set up a new publication on a Veritas Cluster/SQL Server 2005.
The problem i'm having is that sql server reports that in order to do that
"SQL Server replication rquires the actual server name to make a connection
to the server. Connections through a server alias, IP address or any other
alternate name are not supported"
When you run sql on a cluster you virtual names set up. How do i get aroud
this?
Regards
Michael
do this
xp_cmdshell 'hostname'
then do this
select @.@.servername
these should be the same. If not you must do the following
sp_dropserver @.server='OldServerName'
sp_addserver @.server='CorrectServerName', @.local='LOCAL'
As you are on a cluster I am not exactly sure how this is going to work.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Michael_Sergel" <MichaelSergel@.discussions.microsoft.com> wrote in message
news:26053401-B617-4E56-A359-80CB8CDD67D8@.microsoft.com...
> Hi,
> I'm trying to set up a new publication on a Veritas Cluster/SQL Server
> 2005.
> The problem i'm having is that sql server reports that in order to do that
> "SQL Server replication rquires the actual server name to make a
> connection
> to the server. Connections through a server alias, IP address or any other
> alternate name are not supported"
> When you run sql on a cluster you virtual names set up. How do i get aroud
> this?
> Regards
> Michael

New MS SQL Server

How do I backup databases, onto Veritas Backup? In the Enterprise Edition if
I expand the database server I could select all task, backup database and
select the destination. Which is the proper way to backup these databases.
You could get a Veritas agent that will be able to back up the database real
time. The problem with using the plain vanilla Backup EXEC is that it can't
back up a file that is in use. Alternatively, you can use a scheduled task
within Enterprise Manager to back up the database before you backup to tape.
We have ours set up this way and it works well...
Regards,
Hank Arnold
"OSA" <OSA@.discussions.microsoft.com> wrote in message
news:12671BDC-34F2-427E-80EF-753A96DC4818@.microsoft.com...
> How do I backup databases, onto Veritas Backup? In the Enterprise Edition
> if
> I expand the database server I could select all task, backup database and
> select the destination. Which is the proper way to backup these databases.