Showing posts with label raid. Show all posts
Showing posts with label raid. Show all posts

Sunday, March 11, 2012

Error 5177 attempting to create database

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.
>.
>

Error 5172

Hello,

I hava an sql server 2000 sp3a on a win2k sp4 machine running all ok. I tried to build a raid 1 using the hdd where sqlserver was and a new one, but i failed to build it and consecuently i lost all data bases.

Using some programs, i recover the mdf, ldf and ndf files from my old sql server 2000.

I reinstalled all the system exactly the same, win2k sp4 and sql server 2000 with sp3a ( i know sp4 is out ), installed all the apps and overwrites mdf,nfs and ldf files with the old data, and when i tried to put databse online i get this error:

error 5172: header not valid on file "C:\dbtest.mdf". Pageaudit property is not valid.

Any one can help me?http://www.dbforums.com/t749523.html
http://www.lazydba.com/sql/1__728.html

There's lots of stuff out there...just google it...|||well, i've tried this before post with no result. i just ask here becouse i'm very lost.|||I tried command:

exec sp_attach_db @.dbname ... with so meny variation and i get the same error. Can anyone help me?

Thanks.

Error 5172

On detaching a database and trying to re-attach I am getting error 5172. I understand it may be a RAID controller issue but I need a work around after updating the RAID drivers. Anyone else seen this or have a solution?Are you trying to attach an SQL2K database file into SQL7?
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"JonathanS" <anonymous@.discussions.microsoft.com> wrote in message
news:46937F94-4061-445C-ADB9-135DC89FD267@.microsoft.com...
> On detaching a database and trying to re-attach I am getting error 5172. I understand it may be a
RAID controller issue but I need a work around after updating the RAID drivers. Anyone else seen
this or have a solution?|||No. Its all SQL 2000.