Disk Array

Is it possible/okay to store SQL 2K's .mdf's and .ldf's on a disk array?
I would like to attach a SCSI disk array to my server box in order to have
more scaleable storage solution. I have found some information about SAN's
but I don't see why I cannot use a less-expensive disk array to acheive the
same goal. Has anyone tried anything like this before? Thanks....
-dougLocally attached SCSI disk arrays are fine for many environments and quite
common in my experience. SAN solutions are more robust but also more
expensive. We consider SANs for VLDBs and/or storage for multiple servers.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Doug Threewitt" <doug@.seisystems.com> wrote in message
news:ORhbDbx8DHA.488@.TK2MSFTNGP12.phx.gbl...
> Is it possible/okay to store SQL 2K's .mdf's and .ldf's on a disk
array?
> I would like to attach a SCSI disk array to my server box in order to have
> more scaleable storage solution. I have found some information about
SAN's
> but I don't see why I cannot use a less-expensive disk array to acheive
the
> same goal. Has anyone tried anything like this before? Thanks....
>
> -doug
>

Disk Array

Is it possible/okay to store SQL 2K's .mdf's and .ldf's on a disk array?
I would like to attach a SCSI disk array to my server box in order to have
more scaleable storage solution. I have found some information about SAN's
but I don't see why I cannot use a less-expensive disk array to acheive the
same goal. Has anyone tried anything like this before? Thanks....
-dougLocally attached SCSI disk arrays are fine for many environments and quite
common in my experience. SAN solutions are more robust but also more
expensive. We consider SANs for VLDBs and/or storage for multiple servers.
Hope this helps.
Dan Guzman
SQL Server MVP
"Doug Threewitt" <doug@.seisystems.com> wrote in message
news:ORhbDbx8DHA.488@.TK2MSFTNGP12.phx.gbl...
> Is it possible/okay to store SQL 2K's .mdf's and .ldf's on a disk
array?
> I would like to attach a SCSI disk array to my server box in order to have
> more scaleable storage solution. I have found some information about
SAN's
> but I don't see why I cannot use a less-expensive disk array to acheive
the
> same goal. Has anyone tried anything like this before? Thanks....
>
> -doug
>

Disaster..

Scenario:
w2k server sp4
sql server 2k sp3a
I had on USB external disk (160gb from maxtor) 3,34 GB MDF file and LDF
of some size.
Yesterday night I encountered some read errors on it.
W2k suggests me to run CHKDSK /F, that I obviously do.
When system restarts that 3,34 GB MDF file is now size 0kb!!!
Now...
I know that I should have a backup but these data aren't so
important...but If I can retrieve them is better than nothing !!!!!
I'm trying to restore some files with lots of recovery tools but I
notice that all of them find thousands of files...
How can I do, if possible, to obtain my MDF back "full" of data?
Any help MUCH MUCH appreciated...
Best Regards.
--
F.Fabri,
You really shouldn't put SQL Server data files on an exernal USB drive.
Anyway, there's not much you can do in this instance unless you send the
drive off to a specialist for repair (expensive). I have heard that
putting it in the freezer for a few hours can revive it. However, if
your CHKDSK has overwritten or "fixed" sectors on the disk, it is
unlikely you will get the data back without a corrupt MDF file.
I think your only choices here are to restore from backup, or start again.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Fabri wrote:
> Scenario:
> w2k server sp4
> sql server 2k sp3a
>
> I had on USB external disk (160gb from maxtor) 3,34 GB MDF file and LDF
> of some size.
> Yesterday night I encountered some read errors on it.
> W2k suggests me to run CHKDSK /F, that I obviously do.
> When system restarts that 3,34 GB MDF file is now size 0kb!!!
> Now...
> I know that I should have a backup but these data aren't so
> important...but If I can retrieve them is better than nothing !!!!!
> I'm trying to restore some files with lots of recovery tools but I
> notice that all of them find thousands of files...
> How can I do, if possible, to obtain my MDF back "full" of data?
> Any help MUCH MUCH appreciated...
> Best Regards.
>

Disaster : Getting data from LDF files into new SQL Server

I have had a bit of a disaster with our SQL server, and its temporarily
dead. I will reinstall from scratch but I have another SQL server on our
SBS server that I would like to use in the meantime. Can I import or
regsiter those files on the dead server into a database on the SBS sql
server?If you have all the files that constitutes the database (mdf, possibly ndf and ldf), you can try sp_attach_db.
Attach is only guaranteed to work if you cleanly detached the database first, however. It might work even if
you didn't. If it doesn't work, you need to do a restore from a backup.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Child" <dawg@.alaskaSPAMFREE.com> wrote in message news:10ia37qkv0g41db@.corp.supernews.com...
> I have had a bit of a disaster with our SQL server, and its temporarily
> dead. I will reinstall from scratch but I have another SQL server on our
> SBS server that I would like to use in the meantime. Can I import or
> regsiter those files on the dead server into a database on the SBS sql
> server?
>

Disaster : Getting data from LDF files into new SQL Server

I have had a bit of a disaster with our SQL server, and its temporarily
dead. I will reinstall from scratch but I have another SQL server on our
SBS server that I would like to use in the meantime. Can I import or
regsiter those files on the dead server into a database on the SBS sql
server?
If you have all the files that constitutes the database (mdf, possibly ndf and ldf), you can try sp_attach_db.
Attach is only guaranteed to work if you cleanly detached the database first, however. It might work even if
you didn't. If it doesn't work, you need to do a restore from a backup.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Child" <dawg@.alaskaSPAMFREE.com> wrote in message news:10ia37qkv0g41db@.corp.supernews.com...
> I have had a bit of a disaster with our SQL server, and its temporarily
> dead. I will reinstall from scratch but I have another SQL server on our
> SBS server that I would like to use in the meantime. Can I import or
> regsiter those files on the dead server into a database on the SBS sql
> server?
>

Disaster : Getting data from LDF files into new SQL Server

I have had a bit of a disaster with our SQL server, and its temporarily
dead. I will reinstall from scratch but I have another SQL server on our
SBS server that I would like to use in the meantime. Can I import or
regsiter those files on the dead server into a database on the SBS sql
server?If you have all the files that constitutes the database (mdf, possibly ndf a
nd ldf), you can try sp_attach_db.
Attach is only guaranteed to work if you cleanly detached the database first
, however. It might work even if
you didn't. If it doesn't work, you need to do a restore from a backup.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Child" <dawg@.alaskaSPAMFREE.com> wrote in message news:10ia37qkv0g41db@.corp.supernews.com..
.
> I have had a bit of a disaster with our SQL server, and its temporarily
> dead. I will reinstall from scratch but I have another SQL server on our
> SBS server that I would like to use in the meantime. Can I import or
> regsiter those files on the dead server into a database on the SBS sql
> server?
>