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.

Disk Crash, How to restore databases from backups.

3 posts in Windows NT Last posting was on 1998-02-03 17:42:04.0Z
Rick Lathrop Posted on 1998-01-28 21:50:47.0Z
Message-ID: <34CFA837.96F24D5D@npark.com>
Date: Wed, 28 Jan 1998 16:50:47 -0500
From: Rick Lathrop <rickl@npark.com>
X-Mailer: Mozilla 4.04 [en] (WinNT; I)
MIME-Version: 1.0
Subject: Disk Crash, How to restore databases from backups.
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 12
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5263
Article PK: 1081329

The hard drive on our server crashed. I have reinstalled the SQL server
program and want to rebuild the databases from backups. How do I do
this? When I attempt the Load Database command I recieve a message
stating the database does'nt have enough size?
I am an admitted newbie at this, perhaps someone could just recommend a
good book on SQL so I can learn how to do this. The Sybase manuals make
no sense to me.
Lost,
Rick
North Park Studios


Bret Halford Posted on 1998-02-03 17:42:04.0Z
Message-ID: <34D756EB.52C5@sybase.com>
Date: Tue, 03 Feb 1998 10:42:04 -0700
From: Bret Halford <bret@sybase.com>
Organization: Customer Service & Support
X-Mailer: Mozilla 3.0 (X11; U; SunOS 5.5.1 sun4m)
MIME-Version: 1.0
To: Rick Lathrop <rickl@npark.com>
Subject: Re: Disk Crash, How to restore databases from backups.
References: <34CFA837.96F24D5D@npark.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 37
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5247
Article PK: 1081327


Rick Lathrop wrote:
>
> The hard drive on our server crashed. I have reinstalled the SQL server
> program and want to rebuild the databases from backups. How do I do
> this? When I attempt the Load Database command I recieve a message
> stating the database does'nt have enough size?
> I am an admitted newbie at this, perhaps someone could just recommend a
> good book on SQL so I can learn how to do this. The Sybase manuals make
> no sense to me.

It sounds like you have a good start (as you do have the backups :-)

When you create a database, you create it to be a certain size.
I'm sure you have already seen this when you created the database
to load the dump into. Over time, you may also alter it to make
it larger. Regardless of how much data is in the database, it still
has a certain static size.

When you dump a database, the dump knows the size of the original
database. You cannot load it into a smaller database, but you
can load it into one of the same size or larger.

Recent versions will tell you, if you try to load a dump into
a database that is too small, how much additional space is needed.
If the version you are using does not tell you this, you will
have to experiment by making the database larger and larger until
the dump loads.
--
Bret Halford Imagine my disappointment
Sybase Technical Support in learning the true nature
3665 Discovery Drive of rec.humor.oracle...
Boulder, CO 80303


John McVicker Posted on 1998-01-29 03:39:30.0Z
Message-ID: <34CFF9F1.36CB1AD@sybase.com>
Date: Wed, 28 Jan 1998 22:39:30 -0500
From: John McVicker <mcvicker@sybase.com>
Reply-To: mcvicker@sybase.com
Organization: Sybase Professional Services
X-Mailer: Mozilla 4.04 [en] (Win95; U)
MIME-Version: 1.0
To: Rick Lathrop <rickl@npark.com>
Subject: Re: Disk Crash, How to restore databases from backups.
References: <34CFA837.96F24D5D@npark.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 80
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5262
Article PK: 1081345

Rick,
I recently walked someone through doing this at a local company.
I'm not with Sybase Tech Support, but work in Professional Services.
I would suggest one of a few things:
- Either get someone local from Sybase to come out and help
onsite with you (maybe a 1-day contract with SPS)
- Call Sybase Tech Support and escalate to someone who
has rebuilt things like sysusages/sysdevices to match a broken
server.

Don't be lost on this. We all learn about data storage options when
it is too late. The customer I recently worked with had a nice happy server

running Sybase 4.9.2 for 2+ years on File System devices (not always
a safe thing). But they had a disk go bad (and they do go bad!). What
they learned from the situation is - always setup database storage
with mirroring, either at the Operating System level or in Sybase
SQL Server.

Answers to this are a bit time consuming on the forum here. You
may want to just log a call to Sybase Tech Support and start a case
with them. The time to rebuild such a crashed environment also
depends on the amount of information you have. If your master
device is "good" - meaning not trashed by the loss of the disk, then
you have the DB's original size and device layout. If you had to reload
the master device from and "old" backup, then you may not have all
the required information in place to understand just how big the
DB was. You may get lucky and find that information out - or
it may take some messing around. One way to figure out how
large the DB is is to create a very-large database (bigger than you'd
expect the original was) and load it into that. It will write-out
all device fragments into master..sysusages and then from there,
you can figure out just how big it originally was, resetup the devices
and then re-load.

If you are a newbie and want to give your firm the best recovery
scenario, go with the onsite service and do it right without too much
lost time. Otherwise, the company may be looking over your shoulder
as you try things you're not sure of or things that may not work. I
went through one of those situations back in my early computing days
and didn't find it very comfortable, and terrible on my nerves.

If you need any assistance in setting something like this up, give
me a call on the #s below in my signature lines.

Rick Lathrop wrote:

> The hard drive on our server crashed. I have reinstalled the SQL server
> program and want to rebuild the databases from backups. How do I do
> this? When I attempt the Load Database command I recieve a message
> stating the database does'nt have enough size?
> I am an admitted newbie at this, perhaps someone could just recommend a
> good book on SQL so I can learn how to do this. The Sybase manuals make
> no sense to me.
> Lost,
> Rick
> North Park Studios

--
John McVicker
Principal Consultant, District Lead Architect
Sybase Professional Services
Pennsylvania/New Jersey District
301-896-1765
mcvicker@sybase.com, mcvicker@bellatlantic.net, JohnMcVicker@compuserve.com

http://www.sybase.com
http://www.powersoft.com
http://www.isug.com