database replication / publication ?

Hi,
I'd like to keep an extra copy for database X on SQL server A to SQL server
B. The database X doesn't update very often during the day (but the computer
does have other jobs to run at tthe work hour). Both server A and B run SQL
server 2000 and on the same network. Currently the size of database X's MDF
and LDF are around 6 GB (3GB each). It would be nice to keep database X
always be in sync with its copy, but it is not a must. If the database
replication/publication takes a lot of CPU or is time comsuing, it is OK to
do it with a nightly job.
What is the good practice in the case? Thanks for sharing your thoughts.
Shawn,
for an extra copy of X on a standby server, and where latency is allowed,
I'd consider using Log Shipping. This article helps explain some of the key
differences: http://www.replicationanswers.com/Standby.asp
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Database path contains an Extra Backslash.

I am very new to Sequel Server but we have a SQL 2000 server. One of the
paths inthe database has an extra slash i.e (C:\Progame files\\websense)
Vertias Backup can not back it up if it has an extra slhash. How can I
removed the the extra slas. I am still able to access the data base.
THanks,
MomWhere in the database? Are you refering to database properties where it
tells you the path of your .MDF, .NDF & .LDF files?
Somehow I doubt this has any effect on backup, but I've been wrong before.
"Jon Osborn" <josborn@.pcsii.com> wrote in message
news:uMiOKWjJIHA.5980@.TK2MSFTNGP04.phx.gbl...
>I am very new to Sequel Server but we have a SQL 2000 server. One of the
>paths inthe database has an extra slash i.e (C:\Progame files\\websense)
>Vertias Backup can not back it up if it has an extra slhash. How can I
>removed the the extra slas. I am still able to access the data base.
> THanks,
> Mom
>|||In enterprise manager I right click on the WS631 Database and select
properties.
On the Dara Files tab it has
Filename as ws631 with a location of D:\Program
FIles\Websense\\wslogdb63_1.mdf
Transation log is the same with .ldf at the end
Vertias says the \\ after websense is the problem.
Thanks,
Jon
"Jay" <nospam@.nospam.org> wrote in message
news:%23R8EGWlJIHA.3516@.TK2MSFTNGP02.phx.gbl...
> Where in the database? Are you refering to database properties where it
> tells you the path of your .MDF, .NDF & .LDF files?
> Somehow I doubt this has any effect on backup, but I've been wrong before.
> "Jon Osborn" <josborn@.pcsii.com> wrote in message
> news:uMiOKWjJIHA.5980@.TK2MSFTNGP04.phx.gbl...
>|||Is the data file in "D:\Program FIles\Websense\wslogdb63_1.mdf"?
If so, detach the db, or take the engine offline and change the path.
"Jon Osborn" <josborn@.pcsii.com> wrote in message
news:uTK2KE6JIHA.3672@.TK2MSFTNGP02.phx.gbl...
> In enterprise manager I right click on the WS631 Database and select
> properties.
> On the Dara Files tab it has
> Filename as ws631 with a location of D:\Program
> FIles\Websense\\wslogdb63_1.mdf
> Transation log is the same with .ldf at the end
> Vertias says the \\ after websense is the problem.
> Thanks,
> Jon
>
> "Jay" <nospam@.nospam.org> wrote in message
> news:%23R8EGWlJIHA.3516@.TK2MSFTNGP02.phx.gbl...
>

Database path contains an Extra Backslash.

I am very new to Sequel Server but we have a SQL 2000 server. One of the
paths inthe database has an extra slash i.e (C:\Progame files\\websense)
Vertias Backup can not back it up if it has an extra slhash. How can I
removed the the extra slas. I am still able to access the data base.
THanks,
Mom
Where in the database? Are you refering to database properties where it
tells you the path of your .MDF, .NDF & .LDF files?
Somehow I doubt this has any effect on backup, but I've been wrong before.
"Jon Osborn" <josborn@.pcsii.com> wrote in message
news:uMiOKWjJIHA.5980@.TK2MSFTNGP04.phx.gbl...
>I am very new to Sequel Server but we have a SQL 2000 server. One of the
>paths inthe database has an extra slash i.e (C:\Progame files\\websense)
>Vertias Backup can not back it up if it has an extra slhash. How can I
>removed the the extra slas. I am still able to access the data base.
> THanks,
> Mom
>
|||In enterprise manager I right click on the WS631 Database and select
properties.
On the Dara Files tab it has
Filename as ws631 with a location of D:\Program
FIles\Websense\\wslogdb63_1.mdf
Transation log is the same with .ldf at the end
Vertias says the \\ after websense is the problem.
Thanks,
Jon
"Jay" <nospam@.nospam.org> wrote in message
news:%23R8EGWlJIHA.3516@.TK2MSFTNGP02.phx.gbl...
> Where in the database? Are you refering to database properties where it
> tells you the path of your .MDF, .NDF & .LDF files?
> Somehow I doubt this has any effect on backup, but I've been wrong before.
> "Jon Osborn" <josborn@.pcsii.com> wrote in message
> news:uMiOKWjJIHA.5980@.TK2MSFTNGP04.phx.gbl...
>
|||Is the data file in "D:\Program FIles\Websense\wslogdb63_1.mdf"?
If so, detach the db, or take the engine offline and change the path.
"Jon Osborn" <josborn@.pcsii.com> wrote in message
news:uTK2KE6JIHA.3672@.TK2MSFTNGP02.phx.gbl...
> In enterprise manager I right click on the WS631 Database and select
> properties.
> On the Dara Files tab it has
> Filename as ws631 with a location of D:\Program
> FIles\Websense\\wslogdb63_1.mdf
> Transation log is the same with .ldf at the end
> Vertias says the \\ after websense is the problem.
> Thanks,
> Jon
>
> "Jay" <nospam@.nospam.org> wrote in message
> news:%23R8EGWlJIHA.3516@.TK2MSFTNGP02.phx.gbl...
>

Database path contains an Extra Backslash.

I am very new to Sequel Server but we have a SQL 2000 server. One of the
paths inthe database has an extra slash i.e (C:\Progame files\\websense)
Vertias Backup can not back it up if it has an extra slhash. How can I
removed the the extra slas. I am still able to access the data base.
THanks,
MomWhere in the database? Are you refering to database properties where it
tells you the path of your .MDF, .NDF & .LDF files?
Somehow I doubt this has any effect on backup, but I've been wrong before.
"Jon Osborn" <josborn@.pcsii.com> wrote in message
news:uMiOKWjJIHA.5980@.TK2MSFTNGP04.phx.gbl...
>I am very new to Sequel Server but we have a SQL 2000 server. One of the
>paths inthe database has an extra slash i.e (C:\Progame files\\websense)
>Vertias Backup can not back it up if it has an extra slhash. How can I
>removed the the extra slas. I am still able to access the data base.
> THanks,
> Mom
>|||In enterprise manager I right click on the WS631 Database and select
properties.
On the Dara Files tab it has
Filename as ws631 with a location of D:\Program
FIles\Websense\\wslogdb63_1.mdf
Transation log is the same with .ldf at the end
Vertias says the \\ after websense is the problem.
Thanks,
Jon
"Jay" <nospam@.nospam.org> wrote in message
news:%23R8EGWlJIHA.3516@.TK2MSFTNGP02.phx.gbl...
> Where in the database? Are you refering to database properties where it
> tells you the path of your .MDF, .NDF & .LDF files?
> Somehow I doubt this has any effect on backup, but I've been wrong before.
> "Jon Osborn" <josborn@.pcsii.com> wrote in message
> news:uMiOKWjJIHA.5980@.TK2MSFTNGP04.phx.gbl...
>>I am very new to Sequel Server but we have a SQL 2000 server. One of the
>>paths inthe database has an extra slash i.e (C:\Progame files\\websense)
>>Vertias Backup can not back it up if it has an extra slhash. How can I
>>removed the the extra slas. I am still able to access the data base.
>> THanks,
>> Mom
>|||Is the data file in "D:\Program FIles\Websense\wslogdb63_1.mdf"?
If so, detach the db, or take the engine offline and change the path.
"Jon Osborn" <josborn@.pcsii.com> wrote in message
news:uTK2KE6JIHA.3672@.TK2MSFTNGP02.phx.gbl...
> In enterprise manager I right click on the WS631 Database and select
> properties.
> On the Dara Files tab it has
> Filename as ws631 with a location of D:\Program
> FIles\Websense\\wslogdb63_1.mdf
> Transation log is the same with .ldf at the end
> Vertias says the \\ after websense is the problem.
> Thanks,
> Jon
>
> "Jay" <nospam@.nospam.org> wrote in message
> news:%23R8EGWlJIHA.3516@.TK2MSFTNGP02.phx.gbl...
>> Where in the database? Are you refering to database properties where it
>> tells you the path of your .MDF, .NDF & .LDF files?
>> Somehow I doubt this has any effect on backup, but I've been wrong
>> before.
>> "Jon Osborn" <josborn@.pcsii.com> wrote in message
>> news:uMiOKWjJIHA.5980@.TK2MSFTNGP04.phx.gbl...
>>I am very new to Sequel Server but we have a SQL 2000 server. One of the
>>paths inthe database has an extra slash i.e (C:\Progame files\\websense)
>>Vertias Backup can not back it up if it has an extra slhash. How can I
>>removed the the extra slas. I am still able to access the data base.
>> THanks,
>> Mom
>>
>