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.

backup intregrity

7 posts in General Discussion Last posting was on 2012-06-20 12:59:16.0Z
newbiz Posted on 2012-06-19 02:16:36.0Z
Sender: 117f.4fdfe054.1804289383@sybase.com
From: newbiz
Newsgroups: sybase.public.ase.general
Subject: backup intregrity
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4fdfe104.119f.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 18 Jun 2012 19:16:36 -0700
X-Trace: forums-1-dub 1340072196 172.20.134.41 (18 Jun 2012 19:16:36 -0700)
X-Original-Trace: 18 Jun 2012 19:16:36 -0700, 172.20.134.41
Lines: 6
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31196
Article PK: 74085

Hi,

how do I check the integrity of my database backup in sybase
ASE 12.5? Platform would in Sun solaris. Thanks

newbiz


Manish Negandhi [TeamSybase] Posted on 2012-06-19 04:04:25.0Z
From: "Manish Negandhi [TeamSybase]" <nospam_negandhi.manish@gmail.com>
Newsgroups: sybase.public.ase.general
References: <4fdfe104.119f.1681692777@sybase.com>
Subject: Re: backup intregrity
Lines: 23
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3664
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3664
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4fdffa49@forums-1-dub>
Date: 18 Jun 2012 21:04:25 -0700
X-Trace: forums-1-dub 1340078665 10.22.241.152 (18 Jun 2012 21:04:25 -0700)
X-Original-Trace: 18 Jun 2012 21:04:25 -0700, vip152.sybase.com
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31197
Article PK: 74086


<newbiz> wrote in message news:4fdfe104.119f.1681692777@sybase.com...
> Hi,
>
> how do I check the integrity of my database backup in sybase
> ASE 12.5? Platform would in Sun solaris. Thanks
>
> newbiz

You can execute dbcc checkstorage and checkcatalog before executing backup
command to ensure your backup will be clean As a practice you should always
execute such consistency checks regularly to proactively identify any
problems, most shops do not execute dbcc before backup as they already have

them running during weekends or maint windows




-HTH
Manish Negandhi
[TeamSybase]


Rob V Posted on 2012-06-19 08:26:34.0Z
From: Rob V <rob@sypron.nl>
Reply-To: rob@sypron.nl
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:12.0) Gecko/20120428 Thunderbird/12.0.1
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: backup intregrity
References: <4fdfe104.119f.1681692777@sybase.com>
In-Reply-To: <4fdfe104.119f.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4fe037ba$1@forums-1-dub>
Date: 19 Jun 2012 01:26:34 -0700
X-Trace: forums-1-dub 1340094394 10.22.241.152 (19 Jun 2012 01:26:34 -0700)
X-Original-Trace: 19 Jun 2012 01:26:34 -0700, vip152.sybase.com
Lines: 36
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31198
Article PK: 74087


On 19-Jun-2012 04:16, newbiz wrote:
> Hi,
>
> how do I check the integrity of my database backup in sybase
> ASE 12.5? Platform would in Sun solaris. Thanks
>
> newbiz

One way is to load the backup into a test database - which means the
full database dump followed by any incremental transaction log dumps.
You'd be surprised how often this is forgotten to be tested (since the
purpose of a backup is to eventually restore it, it makes sense to test).
Once loaded, run dbcc checks on the database.

If you're running 12.5.4, you can also run dbcc checks directly on the
database dump file using the 'archive database' feature (you don't have
to load the database dump first).

--
HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Professional DBA for Sybase ASE, IQ, Replication Server

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE"
"The Complete Sybase IQ Quick Reference Guide" (new!)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter: @rob_verschoor
Sypron B.V., The Netherlands | Chamber of Commerce 27138666
-----------------------------------------------------------------


newbiz Posted on 2012-06-19 09:32:36.0Z
Sender: 2233.4fe0431f.1804289383@sybase.com
From: newbiz
Newsgroups: sybase.public.ase.general
Subject: Re: backup intregrity
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4fe04734.22aa.1681692777@sybase.com>
References: <4fe037ba$1@forums-1-dub>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 19 Jun 2012 02:32:36 -0700
X-Trace: forums-1-dub 1340098356 172.20.134.41 (19 Jun 2012 02:32:36 -0700)
X-Original-Trace: 19 Jun 2012 02:32:36 -0700, 172.20.134.41
Lines: 47
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31199
Article PK: 74088


> On 19-Jun-2012 04:16, newbiz wrote:
> > Hi,
> >
> > how do I check the integrity of my database backup in
> > sybase ASE 12.5? Platform would in Sun solaris. Thanks
> >
> > newbiz
>
> One way is to load the backup into a test database - which
> means the full database dump followed by any incremental
> transaction log dumps. You'd be surprised how often this
> is forgotten to be tested (since the purpose of a backup
> is to eventually restore it, it makes sense to test). Once
> loaded, run dbcc checks on the database.
>
> If you're running 12.5.4, you can also run dbcc checks
> directly on the database dump file using the 'archive
> database' feature (you don't have to load the database
> dump first).
>
> --
> HTH,
>
> Rob V.
> ----------------------------------------------------------
> ------- Rob Verschoor
>
> Certified Professional DBA for Sybase ASE, IQ, Replication
> Server
>
> Author of Sybase books (order online at
> www.sypron.nl/shop): "Tips, Tricks & Recipes for Sybase
> ASE" "The Complete Sybase IQ Quick Reference Guide" (new!)
> "The Complete Sybase ASE Quick Reference Guide"
> "The Complete Sybase Replication Server Quick Reference
> Guide"
>
> rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter:
> @rob_verschoor Sypron B.V., The Netherlands | Chamber of
> Commerce 27138666
> ----------------------------------------------------------
> -------

Thanks a lot, would this be applicable to dump system
databases also? BTW, under what circumstances/scenarios
would I be needing backup/dump system databases? (i.e master
database)


Rob V Posted on 2012-06-19 10:06:46.0Z
From: Rob V <rob@sypron.nl>
Reply-To: rob@sypron.nl
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:12.0) Gecko/20120428 Thunderbird/12.0.1
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: backup intregrity
References: <4fe037ba$1@forums-1-dub> <4fe04734.22aa.1681692777@sybase.com>
In-Reply-To: <4fe04734.22aa.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4fe04f36$1@forums-1-dub>
Date: 19 Jun 2012 03:06:46 -0700
X-Trace: forums-1-dub 1340100406 10.22.241.152 (19 Jun 2012 03:06:46 -0700)
X-Original-Trace: 19 Jun 2012 03:06:46 -0700, vip152.sybase.com
Lines: 66
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31200
Article PK: 74090


On 19-Jun-2012 11:32, newbiz wrote:
>> On 19-Jun-2012 04:16, newbiz wrote:
>>> Hi,
>>>
>>> how do I check the integrity of my database backup in
>>> sybase ASE 12.5? Platform would in Sun solaris. Thanks
>>>
>>> newbiz
>>
>> One way is to load the backup into a test database - which
>> means the full database dump followed by any incremental
>> transaction log dumps. You'd be surprised how often this
>> is forgotten to be tested (since the purpose of a backup
>> is to eventually restore it, it makes sense to test). Once
>> loaded, run dbcc checks on the database.
>>
>> If you're running 12.5.4, you can also run dbcc checks
>> directly on the database dump file using the 'archive
>> database' feature (you don't have to load the database
>> dump first).
>>
>> --
>> HTH,
>>
>> Rob V.
>> ----------------------------------------------------------
>> ------- Rob Verschoor
>>
>> Certified Professional DBA for Sybase ASE, IQ, Replication
>> Server
>>
>> Author of Sybase books (order online at
>> www.sypron.nl/shop): "Tips, Tricks& Recipes for Sybase
>> ASE" "The Complete Sybase IQ Quick Reference Guide" (new!)
>> "The Complete Sybase ASE Quick Reference Guide"
>> "The Complete Sybase Replication Server Quick Reference
>> Guide"
>>
>> rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter:
>> @rob_verschoor Sypron B.V., The Netherlands | Chamber of
>> Commerce 27138666
>> ----------------------------------------------------------
>> -------
>
> Thanks a lot, would this be applicable to dump system
> databases also? BTW, under what circumstances/scenarios
> would I be needing backup/dump system databases? (i.e master
> database)

You only need to dump the master database, the other system database can
be recreated. You need a backup of the master database (do daily DB dump
only, no log dumps) in case you lose the ASE server and you need to
reconstruct it. First you load the master database and after that you
can start recreating the user databases and loading their dumps back in.

Note that laoding the master database dump is a little different from
loading a regular user DB dump: you need to start the ASE server with
the -m option and you may need to do some custom setup first. Also, ASE
shuts down automatically once the master DB dump is loaded. See the ASE
system admin guide for full details.
For the reasons above, never try to load a master DB dump in a
production server of a server used by other users!

HTH,

Rob V.


Bret Halford Posted on 2012-06-19 15:30:44.0Z
From: Bret Halford <bret@sybase.com>
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:12.0) Gecko/20120428 Thunderbird/12.0.1
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: backup intregrity
References: <4fe037ba$1@forums-1-dub> <4fe04734.22aa.1681692777@sybase.com> <4fe04f36$1@forums-1-dub>
In-Reply-To: <4fe04f36$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4fe09b24$1@forums-1-dub>
Date: 19 Jun 2012 08:30:44 -0700
X-Trace: forums-1-dub 1340119844 10.22.241.152 (19 Jun 2012 08:30:44 -0700)
X-Original-Trace: 19 Jun 2012 08:30:44 -0700, vip152.sybase.com
Lines: 23
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31201
Article PK: 74092


On 6/19/2012 4:06 AM, Rob V wrote:

> You only need to dump the master database, the other system database can
> be recreated.

Some possible exceptions:

Some sites add common objects (defaults, user defined functions,
JAVA classes, etc.) to the model database so the objects
will automatically exist in any newly created database.
If your site does this then it may make sense to also dump
model - though I advise also maintaining
a script that can be run to rebuild these items in model as well.

Some sites add custom procedures to sybsystemprocs, in which
case taking dumps and maintaining a script are again good ideas.

Cheers,
-bret