Compaq server with two channel controler, channel 1 is D:
(67GB)drive channel 2 is E: (67GB). Both RAID 1+0. SQL
does not show the E: drive and generates a 5177 error when
attempting to create database. Operating system on C:
mirrored on two drives.
Operating system Windows 2000 Server, SQL 2000 updated to
SP2. Currently version of Best MAS 500 v6.2 won't work
with SP3.
Problem began when one of the database logfiles which had
been operating for 8 months expanded to consume 50GB of
remaining space on the drive. Attempted to Shrink but
didn't work. Removed the databse and attmepted to
reinstall with data on D: and logs on E: but constantly
run into the error.
Was able to successfully add the database and logs by
keeping both on the D: drive. That's not how we want it
configured.Here's a KB article that may be of help:
http://support.microsoft.com/default.aspx?kbid=239759
I assume that the E partition does have space free, and
you can write to it outside of SQL. Be sure to check the
Event log for possible I/O related problems, as this
could be hardware related. If you see general I/O
errors, you'll probably want to contact your hardware
vendor.
You probably already know this by now, but to avoid the
log eating all of the space, be sure to make regular
backups of the log. A full database backup does NOT
clean out the log file. The easiest way of doing this is
to set up a SQL Maintenance plan to backup the log and
maintain a set history of backups (e.g., 2 weeks worth).
Hope that helps.
>--Original Message--
>Compaq server with two channel controler, channel 1 is
D:
>(67GB)drive channel 2 is E: (67GB). Both RAID 1+0. SQL
>does not show the E: drive and generates a 5177 error
when
>attempting to create database. Operating system on C:
>mirrored on two drives.
>Operating system Windows 2000 Server, SQL 2000 updated
to
>SP2. Currently version of Best MAS 500 v6.2 won't work
>with SP3.
>Problem began when one of the database logfiles which
had
>been operating for 8 months expanded to consume 50GB of
>remaining space on the drive. Attempted to Shrink but
>didn't work. Removed the databse and attmepted to
>reinstall with data on D: and logs on E: but constantly
>run into the error.
>Was able to successfully add the database and logs by
>keeping both on the D: drive. That's not how we want it
>configured.
>.
>
No comments:
Post a Comment