Database mirroring setup without downtime

Does anyone know if you can mirror a database while users are banging away on
it? I can't see how I'd get the log backups in sync on the mirror server,
it's pretty busy with transactions. I've done some small scale testing and it
seems like you can apply a log backup while the data on the primary is being
changed and it still sets up the mirror ok. It's a 24/7 system and we have to
schedule some downtime otherwise.
Thanks in advance.
Hi
How do you know that log backups are ansync?
"sqlboy2000" <sqlboy2000@.discussions.microsoft.com> wrote in message
news:98F90C89-B307-4FB3-85D1-ACA8CA2D2297@.microsoft.com...
> Does anyone know if you can mirror a database while users are banging away
> on
> it? I can't see how I'd get the log backups in sync on the mirror server,
> it's pretty busy with transactions. I've done some small scale testing and
> it
> seems like you can apply a log backup while the data on the primary is
> being
> changed and it still sets up the mirror ok. It's a 24/7 system and we have
> to
> schedule some downtime otherwise.
> Thanks in advance.

Database mirroring setup without downtime

Does anyone know if you can mirror a database while users are banging away o
n
it? I can't see how I'd get the log backups in sync on the mirror server,
it's pretty busy with transactions. I've done some small scale testing and i
t
seems like you can apply a log backup while the data on the primary is being
changed and it still sets up the mirror ok. It's a 24/7 system and we have t
o
schedule some downtime otherwise.
Thanks in advance.Hi
How do you know that log backups are ansync?
"sqlboy2000" <sqlboy2000@.discussions.microsoft.com> wrote in message
news:98F90C89-B307-4FB3-85D1-ACA8CA2D2297@.microsoft.com...
> Does anyone know if you can mirror a database while users are banging away
> on
> it? I can't see how I'd get the log backups in sync on the mirror server,
> it's pretty busy with transactions. I've done some small scale testing and
> it
> seems like you can apply a log backup while the data on the primary is
> being
> changed and it still sets up the mirror ok. It's a 24/7 system and we have
> to
> schedule some downtime otherwise.
> Thanks in advance.

Database mirroring setup without downtime

Does anyone know if you can mirror a database while users are banging away on
it? I can't see how I'd get the log backups in sync on the mirror server,
it's pretty busy with transactions. I've done some small scale testing and it
seems like you can apply a log backup while the data on the primary is being
changed and it still sets up the mirror ok. It's a 24/7 system and we have to
schedule some downtime otherwise.
Thanks in advance.Hi
How do you know that log backups are ansync?
"sqlboy2000" <sqlboy2000@.discussions.microsoft.com> wrote in message
news:98F90C89-B307-4FB3-85D1-ACA8CA2D2297@.microsoft.com...
> Does anyone know if you can mirror a database while users are banging away
> on
> it? I can't see how I'd get the log backups in sync on the mirror server,
> it's pretty busy with transactions. I've done some small scale testing and
> it
> seems like you can apply a log backup while the data on the primary is
> being
> changed and it still sets up the mirror ok. It's a 24/7 system and we have
> to
> schedule some downtime otherwise.
> Thanks in advance.

Database Migration

Need advice on how to best achieve migrating a 20 GB database to a new serve
r
without any downtime.
Would Backup+Differential Backup+transaction log backup up a solution ?
Is replication the way to go?
Any advice would be appretiated.
Many thanks in advance
ShahriarYou mean from Sql Server to another Sql Server?
"Shahriar" wrote:

> Need advice on how to best achieve migrating a 20 GB database to a new ser
ver
> without any downtime.
> Would Backup+Differential Backup+transaction log backup up a solution ?
> Is replication the way to go?
> Any advice would be appretiated.
> Many thanks in advance
> Shahriar|||yes
"Enric" wrote:
> You mean from Sql Server to another Sql Server?
> "Shahriar" wrote:
>

Database maintainance

I am about to work with a database of approx 200GB on RAID5 volume. This database is very crutial and there should absolutly no/very less downtime. Since I've never worked so huge database and that too running on RAID 5. So can anyone help me in describing the steps or the check list to be prepared before working with its maintainance or may I be provided with cautions I supposed to takeHi Sunny.
If your database is crucial, then there will be many things you need to take
into consideration. Raid5 may be good enough, especially if your database is
read intensive but if the database is write intensive, (more inserts,
updates, deletes than selects) then raid5 is probably not the best choice as
raid10 will offer better write performance (costs more).
There are just so many issues that you need to consider when planning a
crucial database that need to be up all of the time. I suggest you at least
have a look at some of the good articles on Microsoft's website:
http://www.microsoft.com/sql/techinfo/administration/2000/default.asp
& good luck!
Regards,
Greg Linwood
SQL Server MVP
"Sunny" <anonymous@.discussions.microsoft.com> wrote in message
news:621B8B20-724A-4D31-AB80-7FEB66443B53@.microsoft.com...
> I am about to work with a database of approx 200GB on RAID5 volume. This
database is very crutial and there should absolutly no/very less downtime.
Since I've never worked so huge database and that too running on RAID 5. So
can anyone help me in describing the steps or the check list to be prepared
before working with its maintainance or may I be provided with cautions I
supposed to take.
>