Complete, Differential, Transaction Log -- More backup questions

Greetings all,
I am new to this Newsgroup, so forgive me if my question seems stupid.
We currently have a payroll system that runs on SQL Server 2000. We are
doing a full backup (to a local hard disk) every night of the main database,
which is about 55GB and then sending the SQL Backup off to tape. We can keep
2, maybe 3 days backup online, but space is getting tight.
I have suggested that we do 1 complete backup at the beginning of the
week, then a Differential backup every night, and a transaction log backup
every couple of hours during the day.
My question for you people. If I do the complete backup on Sunday
night, a differential on Monday and Tuesday night, and a couple of
Transaction Log backups on Wednesday, and the System crashes late Wednesday
do I have to restore both Mon and Tue differential and all the Wed
Transaction Logs and restoring the complete from Sun, or can I just restore
the Sun complete, the Tue night differential and the last Transaction Log
from Wed?
I think my actual question is: "Is the Differential backup all the
differences from the last complete or the last Differential, and does the
Transaction Log backup get everything from the last Differential?"
Thanks much
Raymond Fantasia
Fry''s Electronics
ISD DepartmentHi
answered in microsoft.public.sqlserver.newusers
Please do not multi-post as it is harder to know if the question has been
answered yet.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Ray Fantasia" <RayFantasia@.discussions.microsoft.com> wrote in message
news:A8241F2A-6630-4B96-A9A0-2CB30BEEA7E9@.microsoft.com...
> Greetings all,
> I am new to this Newsgroup, so forgive me if my question seems stupid.
> We currently have a payroll system that runs on SQL Server 2000. We are
> doing a full backup (to a local hard disk) every night of the main
> database,
> which is about 55GB and then sending the SQL Backup off to tape. We can
> keep
> 2, maybe 3 days backup online, but space is getting tight.
> I have suggested that we do 1 complete backup at the beginning of the
> week, then a Differential backup every night, and a transaction log backup
> every couple of hours during the day.
> My question for you people. If I do the complete backup on Sunday
> night, a differential on Monday and Tuesday night, and a couple of
> Transaction Log backups on Wednesday, and the System crashes late
> Wednesday
> do I have to restore both Mon and Tue differential and all the Wed
> Transaction Logs and restoring the complete from Sun, or can I just
> restore
> the Sun complete, the Tue night differential and the last Transaction Log
> from Wed?
> I think my actual question is: "Is the Differential backup all the
> differences from the last complete or the last Differential, and does the
> Transaction Log backup get everything from the last Differential?"
> Thanks much
> Raymond Fantasia
> Fry''s Electronics
> ISD Department

Complete, Differential, Transaction Log -- More backup questions

Greetings all,
I am new to this Newsgroup, so forgive me if my question seems stupid.
We currently have a payroll system that runs on SQL Server 2000. We are
doing a full backup (to a local hard disk) every night of the main database,
which is about 55GB and then sending the SQL Backup off to tape. We can kee
p
2, maybe 3 days backup online, but space is getting tight.
I have suggested that we do 1 complete backup at the beginning of the
week, then a Differential backup every night, and a transaction log backup
every couple of hours during the day.
My question for you people. If I do the complete backup on Sunday
night, a differential on Monday and Tuesday night, and a couple of
Transaction Log backups on Wednesday, and the System crashes late Wednesday
do I have to restore both Mon and Tue differential and all the Wed
Transaction Logs and restoring the complete from Sun, or can I just restore
the Sun complete, the Tue night differential and the last Transaction Log
from Wed?
I think my actual question is: "Is the Differential backup all the
differences from the last complete or the last Differential, and does the
Transaction Log backup get everything from the last Differential?"
Thanks much
Raymond Fantasia
Fry''s Electronics
ISD DepartmentHi
answered in microsoft.public.sqlserver.newusers
Please do not multi-post as it is harder to know if the question has been
answered yet.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Ray Fantasia" <RayFantasia@.discussions.microsoft.com> wrote in message
news:A8241F2A-6630-4B96-A9A0-2CB30BEEA7E9@.microsoft.com...
> Greetings all,
> I am new to this Newsgroup, so forgive me if my question seems stupid.
> We currently have a payroll system that runs on SQL Server 2000. We are
> doing a full backup (to a local hard disk) every night of the main
> database,
> which is about 55GB and then sending the SQL Backup off to tape. We can
> keep
> 2, maybe 3 days backup online, but space is getting tight.
> I have suggested that we do 1 complete backup at the beginning of the
> week, then a Differential backup every night, and a transaction log backup
> every couple of hours during the day.
> My question for you people. If I do the complete backup on Sunday
> night, a differential on Monday and Tuesday night, and a couple of
> Transaction Log backups on Wednesday, and the System crashes late
> Wednesday
> do I have to restore both Mon and Tue differential and all the Wed
> Transaction Logs and restoring the complete from Sun, or can I just
> restore
> the Sun complete, the Tue night differential and the last Transaction Log
> from Wed?
> I think my actual question is: "Is the Differential backup all the
> differences from the last complete or the last Differential, and does the
> Transaction Log backup get everything from the last Differential?"
> Thanks much
> Raymond Fantasia
> Fry''s Electronics
> ISD Department

Complete, Differential, Transaction Log -- More backup questions

Greetings all,
I am new to this Newsgroup, so forgive me if my question seems stupid.
We currently have a payroll system that runs on SQL Server 2000. We are
doing a full backup (to a local hard disk) every night of the main database,
which is about 55GB and then sending the SQL Backup off to tape. We can keep
2, maybe 3 days backup online, but space is getting tight.
I have suggested that we do 1 complete backup at the beginning of the
week, then a Differential backup every night, and a transaction log backup
every couple of hours during the day.
My question for you people. If I do the complete backup on Sunday
night, a differential on Monday and Tuesday night, and a couple of
Transaction Log backups on Wednesday, and the System crashes late Wednesday
do I have to restore both Mon and Tue differential and all the Wed
Transaction Logs and restoring the complete from Sun, or can I just restore
the Sun complete, the Tue night differential and the last Transaction Log
from Wed?
I think my actual question is: "Is the Differential backup all the
differences from the last complete or the last Differential, and does the
Transaction Log backup get everything from the last Differential?"
Thanks much
Raymond Fantasia
Fry''s Electronics
ISD Department
Hi
answered in microsoft.public.sqlserver.newusers
Please do not multi-post as it is harder to know if the question has been
answered yet.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Ray Fantasia" <RayFantasia@.discussions.microsoft.com> wrote in message
news:A8241F2A-6630-4B96-A9A0-2CB30BEEA7E9@.microsoft.com...
> Greetings all,
> I am new to this Newsgroup, so forgive me if my question seems stupid.
> We currently have a payroll system that runs on SQL Server 2000. We are
> doing a full backup (to a local hard disk) every night of the main
> database,
> which is about 55GB and then sending the SQL Backup off to tape. We can
> keep
> 2, maybe 3 days backup online, but space is getting tight.
> I have suggested that we do 1 complete backup at the beginning of the
> week, then a Differential backup every night, and a transaction log backup
> every couple of hours during the day.
> My question for you people. If I do the complete backup on Sunday
> night, a differential on Monday and Tuesday night, and a couple of
> Transaction Log backups on Wednesday, and the System crashes late
> Wednesday
> do I have to restore both Mon and Tue differential and all the Wed
> Transaction Logs and restoring the complete from Sun, or can I just
> restore
> the Sun complete, the Tue night differential and the last Transaction Log
> from Wed?
> I think my actual question is: "Is the Differential backup all the
> differences from the last complete or the last Differential, and does the
> Transaction Log backup get everything from the last Differential?"
> Thanks much
> Raymond Fantasia
> Fry''s Electronics
> ISD Department

COMPLETE NEWBIE - sorry :-(

I have mysql running on a windows2003 webserver - it runs a
messageboard and oscommerce. Potential new client wants to replicate
information from the website to her server - is this possible with
mysql or do I need to install sql (proper) ... sorry if I sound like I
don't know fully what I am doing - i dont!!
Any advice or pointers given would be greatly appreciated.
thanks
Jeff
Jeff/Andrew,
this is a MS SQL Server Replication newsgroup - surely there are dedicated
MySQL discussion boards?
Rgds,
Paul Ibison
|||On Sun, 24 Apr 2005 19:07:16 +0100, "Paul Ibison"
<Paul.Ibison@.Pygmalion.Com> wrote:

>Jeff/Andrew,
>this is a MS SQL Server Replication newsgroup - surely there are dedicated
>MySQL discussion boards?
>Rgds,
>Paul Ibison
>
I can't find one and I suspect I will end up installing SQL for
replication - can someone please advise?
|||Have a look at http://forums.mysql.com/list.php?26
From the point of view of SQL Server Replication, you can certainly achieve
your aim. For the new client you need to consider latency (time between
change on the publisher and corresponding change arriving at the subscriber)
, autonomy (can they be offline) and if the subscriber is read-only or
read-write. Answering these will lead to the correct type of replication.
Having SQL Server on the webserver would mean this is the publisher.
Heterogenous subscribers are supported to differing extents, but
connectivity to MYSQL is possible and is illustrated in Hilary's book below.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||while I'd love you to buy my book
1) its covered on the free downloadable sample chapter
http://www.nwsu.com/lowres_replication_ch02.pdf
2) Replication to MySQL doesn't work - or works until the distribution agent
stops and then you have to resync to get it working again due to a SQL
Server bug.
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:%23CtbxJQSFHA.2748@.TK2MSFTNGP09.phx.gbl...
> Have a look at http://forums.mysql.com/list.php?26
> From the point of view of SQL Server Replication, you can certainly
> achieve your aim. For the new client you need to consider latency (time
> between change on the publisher and corresponding change arriving at the
> subscriber) , autonomy (can they be offline) and if the subscriber is
> read-only or read-write. Answering these will lead to the correct type of
> replication. Having SQL Server on the webserver would mean this is the
> publisher. Heterogenous subscribers are supported to differing extents,
> but connectivity to MYSQL is possible and is illustrated in Hilary's book
> below.
> HTH,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||Interesting - thanks for the clarification. In that case your (Andrew's)
client might want to consider MSDE as a replacement for a MySQL subscriber.
Rgds,
Paul Ibison