An accounting application uses a SQL server.
I am going to use two SQL servers for this application. These two SQL
servers are sync between them.
Each night, a copy of the SQL database is copied to a network share, and
then the backup program, ARCserve, will back up the database on the network
share nightly.
Is this approach a best practice? Any pointers/comments/suggestions are
greatly appreciated.
Thanks,What you want to achieve by using 2 servers ? to me using 2 servers for
accounting is not a good idea.
about backup - that is fine if you put databases in sync.
"Doug Fox" wrote:
> An accounting application uses a SQL server.
> I am going to use two SQL servers for this application. These two SQL
> servers are sync between them.
> Each night, a copy of the SQL database is copied to a network share, and
> then the backup program, ARCserve, will back up the database on the networ
k
> share nightly.
> Is this approach a best practice? Any pointers/comments/suggestions are
> greatly appreciated.
> Thanks,
>
>
Wednesday, March 21, 2012
is this disaster recovery / 'high availabilty" setup OK?
Labels:
accounting,
application,
availabilty,
database,
disaster,
microsoft,
mysql,
oracle,
recovery,
server,
servers,
setup,
sql,
sqlservers,
sync
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment