Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Automate backup in NT environment

8 posts in Windows NT Last posting was on 2000-06-13 16:44:38.0Z
teresa young Posted on 2000-06-12 03:03:17.0Z
Message-ID: <394452F5.B379EE45@qware.net>
Date: Mon, 12 Jun 2000 11:03:17 +0800
From: Teresa Young <teresa@qware.net>
X-Mailer: Mozilla 4.5 [zhtw]C-CCK-MCD (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Automate backup in NT environment
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 18
NNTP-Posting-Host: 210.209.57.34
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2047
Article PK: 1089509

Dear All:
We want to automate backup database using following procedure.
1) Shutdown database
2) Start sybase using single user mode (Because, we must sure that
no one use the server.)
3) Backup database we wanted
4)Shutdown database
5)Start sybase normally
Since, we havn't any operator to take care the backup job in
midnight. Could you tell me how to complete these procedures automaticly

in Sybase ASE 11.9.2 and Window NT Server 4.0? I know that we can use
the NT scheduler to run these job. But, we want that every step is
sequential in one xxxxxx.cmd file, not 5 xxxxx.cmd files.
Thank!!!

Best Regards

Teresa Young


Tommy Phillips Posted on 2000-06-12 19:17:23.0Z
Message-ID: <39453743.E98CD67A@sybase.com>
Date: Mon, 12 Jun 2000 13:17:23 -0600
From: Tommy Phillips <tommy@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.73 [en]C-CCK-MCD (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Automate backup in NT environment
References: <394452F5.B379EE45@qware.net>
Content-Type: multipart/mixed; boundary="------------1F320609ABF1E104C354CB24"
Newsgroups: sybase.public.sqlserver.nt
Lines: 29
NNTP-Posting-Host: tommy-lpt.sybase.com 157.133.56.58
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2040
Article PK: 1089503

But why do you want to keep everyone off the server during the backup? It is not necessary to ensure transactional consistency.

Teresa Young wrote:
>
> Dear All:
> We want to automate backup database using following procedure.
> 1) Shutdown database
> 2) Start sybase using single user mode (Because, we must sure that
> no one use the server.)

...


Download VCard tommy.vcf


teresa young Posted on 2000-06-13 04:00:31.0Z
Message-ID: <3945B1DF.9A77B5E@qware.net>
Date: Tue, 13 Jun 2000 12:00:31 +0800
From: Teresa Young <teresa@qware.net>
X-Mailer: Mozilla 4.5 [zhtw]C-CCK-MCD (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Automate backup in NT environment
References: <394452F5.B379EE45@qware.net> <39453743.E98CD67A@sybase.com>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 17
NNTP-Posting-Host: 210.209.57.34
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2038
Article PK: 1089498

How do I ensure the consistency of data if someone else send a transaction to Server when I backup database? If Backup Server
can ensure the consistency of database, we don't need to keep everyone off the server.

Tommy Phillips ¼g¹D¡G

> But why do you want to keep everyone off the server during the backup? It is not necessary to ensure transactional consistency.
>
> Teresa Young wrote:
> >
> > Dear All:
> > We want to automate backup database using following procedure.
> > 1) Shutdown database
> > 2) Start sybase using single user mode (Because, we must sure that
> > no one use the server.)
> ...


Andy Price Posted on 2000-06-13 16:44:38.0Z
From: "Andy Price" <andy.price@canada.com>
References: <394452F5.B379EE45@qware.net> <39453743.E98CD67A@sybase.com> <3945B1DF.9A77B5E@qware.net>
Subject: Re: Automate backup in NT environment
Date: Tue, 13 Jun 2000 17:44:38 +0100
Lines: 41
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <yHdoKaW1$GA.203@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: host213-1-73-253.btinternet.com 213.1.73.253
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2033
Article PK: 1089489

Teresa,

You don't need to kick everyone off the database whilst you backup to ensure
consistency. When the backup happens, Sybase does a checkpoint which writes
all dirty pages to disk for the data and log. Then it copies the database to
your file or tape. At the end of the backup, it writes any additional
changes that were made to the database's data during the backup to the
backup file (ie, the contents of the transaction log).

Your data will be consistent.

--
Andy Price
Sybase Certified Adaptive Server Administrator - Associate v11.5

Teresa Young <teresa@qware.net> wrote in message
news:3945B1DF.9A77B5E@qware.net...
> How do I ensure the consistency of data if someone else send a
transaction to Server when I backup database? If Backup Server
> can ensure the consistency of database, we don't need to keep everyone off
the server.
>
> Tommy Phillips ¼g¹D¡G
>
> > But why do you want to keep everyone off the server during the backup?
It is not necessary to ensure transactional consistency.
> >
> > Teresa Young wrote:
> > >
> > > Dear All:
> > > We want to automate backup database using following procedure.
> > > 1) Shutdown database
> > > 2) Start sybase using single user mode (Because, we must sure that
> > > no one use the server.)
> > ...
>


Tommy Phillips Posted on 2000-06-13 16:41:39.0Z
Message-ID: <39466443.5D9C41E5@sybase.com>
Date: Tue, 13 Jun 2000 10:41:39 -0600
From: Tommy Phillips <tommy@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.73 [en]C-CCK-MCD (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Automate backup in NT environment
References: <394452F5.B379EE45@qware.net> <39453743.E98CD67A@sybase.com> <3945B1DF.9A77B5E@qware.net>
Content-Type: multipart/mixed; boundary="------------2555B13A1734245C45B77580"
Newsgroups: sybase.public.sqlserver.nt
Lines: 56
NNTP-Posting-Host: tommy-lpt.sybase.com 157.133.56.58
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2034
Article PK: 1089491

Teresa-

During the backup process, the server watches the transaction log. Any transactions that begin during the backup but do not complete will not be reflected in the backup. Similarly, any transactions that are open at the beginning of the backup but are committed or rolled back before the end of the backup will be accurately reflected in the backup. (Actually, it's a bit more complex than that, but that is the net effect. More details of this process are available in the Sybase System Administration course.)

The net effect is that any successful backup from an ASE database reflects a transactionally consistent database state. It is a fundamental feature of the ASE transaction management.

-Tommy Phillips

Teresa Young wrote:
>
> How do I ensure the consistency of data if someone else send a transaction to Server when I backup database? If Backup Server
> can ensure the consistency of database, we don't need to keep everyone off the server.
>
> Tommy Phillips ¼g¹D¡G
>
> > But why do you want to keep everyone off the server during the backup? It is not necessary to ensure transactional consistency.
> >
> > Teresa Young wrote:
> > >
> > > Dear All:
> > > We want to automate backup database using following procedure.
> > > 1) Shutdown database
> > > 2) Start sybase using single user mode (Because, we must sure that
> > > no one use the server.)
> > ...


Download VCard tommy.vcf


Tony Imbierski Posted on 2000-06-12 09:01:37.0Z
Message-ID: <3944A6F1.B63EB9E3@sybase.com>
Date: Mon, 12 Jun 2000 10:01:37 +0100
From: Tony Imbierski <tonyi@sybase.com>
X-Mailer: Mozilla 4.72 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Automate backup in NT environment
References: <394452F5.B379EE45@qware.net>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 22
NNTP-Posting-Host: aja.sybase.com 158.76.102.229
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2046
Article PK: 1089504

...so write one xxxxxx.cmd file that calls each of the other 5 xxxxxx.cmd
files sequentially!

Teresa Young wrote:

> Dear All:
> We want to automate backup database using following procedure.
> 1) Shutdown database
> 2) Start sybase using single user mode (Because, we must sure that
> no one use the server.)
> 3) Backup database we wanted
> 4)Shutdown database
> 5)Start sybase normally
> Since, we havn't any operator to take care the backup job in
> midnight. Could you tell me how to complete these procedures automaticly
>
> in Sybase ASE 11.9.2 and Window NT Server 4.0? I know that we can use
> the NT scheduler to run these job. But, we want that every step is
> sequential in one xxxxxx.cmd file, not 5 xxxxx.cmd files.
> Thank!!!
>
> Best Regards
>
> Teresa Young


teresa young Posted on 2000-06-12 09:55:21.0Z
Message-ID: <3944B388.275A57CF@qware.net>
Date: Mon, 12 Jun 2000 17:55:21 +0800
From: Teresa Young <teresa@qware.net>
X-Mailer: Mozilla 4.5 [zhtw]C-CCK-MCD (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Automate backup in NT environment
References: <394452F5.B379EE45@qware.net> <3944A6F1.B63EB9E3@sybase.com>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 27
NNTP-Posting-Host: 210.209.57.34
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2045
Article PK: 1089501

Thanks for your response.
But, will the commands be serialized so that the first xxxx.cmd must
completes before the next xxxx.cmd ?


Tony Imbierski ¼g¹D¡G

> ...so write one xxxxxx.cmd file that calls each of the other 5 xxxxxx.cmd
> files sequentially!
>
> Teresa Young wrote:
>
> > Dear All:
> > We want to automate backup database using following procedure.
> > 1) Shutdown database
> > 2) Start sybase using single user mode (Because, we must sure that
> > no one use the server.)
> > 3) Backup database we wanted
> > 4)Shutdown database
> > 5)Start sybase normally
> > Since, we havn't any operator to take care the backup job in
> > midnight. Could you tell me how to complete these procedures automaticly
> >
> > in Sybase ASE 11.9.2 and Window NT Server 4.0? I know that we can use
> > the NT scheduler to run these job. But, we want that every step is
> > sequential in one xxxxxx.cmd file, not 5 xxxxx.cmd files.
> > Thank!!!
> >
> > Best Regards
> >
> > Teresa Young


Tony Imbierski Posted on 2000-06-12 16:39:17.0Z
Message-ID: <39451234.E59D6325@sybase.com>
Date: Mon, 12 Jun 2000 17:39:17 +0100
From: Tony Imbierski <tonyi@sybase.com>
X-Mailer: Mozilla 4.72 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Automate backup in NT environment
References: <394452F5.B379EE45@qware.net> <3944A6F1.B63EB9E3@sybase.com> <3944B388.275A57CF@qware.net>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 43
NNTP-Posting-Host: aja.sybase.com 158.76.102.229
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2042
Article PK: 1089497

Yes if you write a command file that basically does
call cmdfile1.bat
call cmdfile2.bat

then cmdfile1 and cmdfile2 will execute serially.

If you write
start cmdfile1.bat
start cmdfile2.bat

then cmdfile1 and cmdfile2 will execute in parallel.

If you think about it you will need a combination of these, for example the
command file that starts the server will have to run in parallel otherwise your
main procedure will never get to the next step.

cheers,
tonyi

Teresa Young wrote:

> Thanks for your response.
> But, will the commands be serialized so that the first xxxx.cmd must
> completes before the next xxxx.cmd ?
>
> Tony Imbierski ¼g¹D¡G
>
> > ...so write one xxxxxx.cmd file that calls each of the other 5 xxxxxx.cmd
> > files sequentially!
> >
> > Teresa Young wrote:
> >
> > > Dear All:
> > > We want to automate backup database using following procedure.
> > > 1) Shutdown database
> > > 2) Start sybase using single user mode (Because, we must sure that
> > > no one use the server.)
> > > 3) Backup database we wanted
> > > 4)Shutdown database
> > > 5)Start sybase normally
> > > Since, we havn't any operator to take care the backup job in
> > > midnight. Could you tell me how to complete these procedures automaticly
> > >
> > > in Sybase ASE 11.9.2 and Window NT Server 4.0? I know that we can use
> > > the NT scheduler to run these job. But, we want that every step is
> > > sequential in one xxxxxx.cmd file, not 5 xxxxx.cmd files.
> > > Thank!!!
> > >
> > > Best Regards
> > >
> > > Teresa Young

--
Tony Imbierski
Sybase Engineering

~ everything else is just email ~