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.

Cannot Dump one file on NT

3 posts in Windows NT Last posting was on 1998-02-14 15:37:07.0Z
Chang Ho LEE Posted on 1998-02-13 01:55:08.0Z
From: "Chang Ho LEE" <lch@mail.posdata.co.kr>
Subject: Cannot Dump one file on NT
Date: Fri, 13 Feb 1998 10:55:08 +0900
Lines: 26
X-Newsreader: Microsoft Outlook Express 4.72.2106.4
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Message-ID: <DGxEImBO9GA.205@forums.powersoft.com>
Newsgroups: sybase.public.sqlserver.nt
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5199
Article PK: 1081277

Hi Everyone!
I have two problems on my NT Server.
The first, the size of DB is about 3.5Gyga byte.
When I was Dump the DB, I must Dump the stripe over 2 dump file.
I wanna 1 file backup. But I can't.
If I dump the DB in one file, the file increases until about 1.9 gyga byte.
But, the file don't increase anymore.
And dump process is still running in SQL Server.
What's the problem? Help me, please.
And the scond, Dump Process blocks the a Inserted process.
We submit backup process at 20 o'clock in every evening.
The system is very slowly in this morning.
So I into the SQL Server, and run sp_who & sp_lock.
therr is no infomation sp_lock. But dump process blocks some process.
the process is that read a sam file then insert the Database.
I 've never seen this problem.

My System's Platform.
H/W : Compaq proliant 4500R
O/S : Win NT 3.51 (include Server PACK5)
SYBASE SQL Server 10.0.2


olly Posted on 1998-02-14 02:16:12.0Z
Message-ID: <34E4FE6C.23A2@erols.com>
Date: Fri, 13 Feb 1998 21:16:12 -0500
From: Olly <oamudipe@erols.com>
Reply-To: oamudipexxx@erols.com
X-Mailer: Mozilla 3.01Gold (WinNT; I)
MIME-Version: 1.0
Subject: Re: Cannot Dump one file on NT
References: <DGxEImBO9GA.205@forums.powersoft.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 31
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5190
Article PK: 1081270


Chang Ho LEE wrote:
>
> Hi Everyone!
> I have two problems on my NT Server.
> The first, the size of DB is about 3.5Gyga byte.
> When I was Dump the DB, I must Dump the stripe over 2 dump file.
> I wanna 1 file backup. But I can't.
> If I dump the DB in one file, the file increases until about 1.9 gyga byte.
> But, the file don't increase anymore.
> And dump process is still running in SQL Server.
> What's the problem? Help me, please.
> And the scond, Dump Process blocks the a Inserted process.
> We submit backup process at 20 o'clock in every evening.
> The system is very slowly in this morning.
> So I into the SQL Server, and run sp_who & sp_lock.
> therr is no infomation sp_lock. But dump process blocks some process.
> the process is that read a sam file then insert the Database.
> I 've never seen this problem.
>
> My System's Platform.
> H/W : Compaq proliant 4500R
> O/S : Win NT 3.51 (include Server PACK5)
> SYBASE SQL Server 10.0.2

The problem you discribt will happen if your operating system does not
support files larger tha 2Gig. Call Microsft to verify this and ask if
they have a patch you can add. I believe upgrade to NT 4 will fix the
problem.

Good luck


David Levine Posted on 1998-02-14 15:37:07.0Z
From: "David Levine" <david_levine@opcenter.net>
References: <DGxEImBO9GA.205@forums.powersoft.com> <34E4FE6C.23A2@erols.com>
Subject: Re: Cannot Dump one file on NT
Date: Sat, 14 Feb 1998 10:37:07 -0500
Lines: 50
X-Newsreader: Microsoft Outlook Express 4.72.2106.4
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Message-ID: <dEa6jVVO9GA.205@forums.powersoft.com>
Newsgroups: sybase.public.sqlserver.nt
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5189
Article PK: 1081268

You need to define the partition you are dumping to as NTFS. Fat doesn't
support a partition or file > 2 GB. Also, be very careful about going to NT
4 with Sybase System 10. You can try converting an existing 3.51 server to
4 with Sybase System 10 already installed, but you can't take a new NT 4
server and install System 10 on it. Since NT 4 wasn't out when Sys 10 was
released and you get an error when trying to install. I don't know if you
can get around the error.

We have 6GB dumps on NT without any issue, so it is certainly possible. We
also do not see blocked processes when the dump is occurring. We definitely
see blocked processes when running a DBCC, so we can't do that anymore
(24x7x365).

David

Olly wrote in message <34E4FE6C.23A2@erols.com>...
>Chang Ho LEE wrote:
>>
>> Hi Everyone!
>> I have two problems on my NT Server.
>> The first, the size of DB is about 3.5Gyga byte.
>> When I was Dump the DB, I must Dump the stripe over 2 dump file.
>> I wanna 1 file backup. But I can't.
>> If I dump the DB in one file, the file increases until about 1.9 gyga
byte.
>> But, the file don't increase anymore.
>> And dump process is still running in SQL Server.
>> What's the problem? Help me, please.
>> And the scond, Dump Process blocks the a Inserted process.
>> We submit backup process at 20 o'clock in every evening.
>> The system is very slowly in this morning.
>> So I into the SQL Server, and run sp_who & sp_lock.
>> therr is no infomation sp_lock. But dump process blocks some process.
>> the process is that read a sam file then insert the Database.
>> I 've never seen this problem.
>>
>> My System's Platform.
>> H/W : Compaq proliant 4500R
>> O/S : Win NT 3.51 (include Server PACK5)
>> SYBASE SQL Server 10.0.2
>
>
>The problem you discribt will happen if your operating system does not
>support files larger tha 2Gig. Call Microsft to verify this and ask if
>they have a patch you can add. I believe upgrade to NT 4 will fix the
>problem.
>
>Good luck