Re: Advice Requested : Disaster Recovery with 2 Drives (No Raid) with SQL Server 2008

<<Why are you using Enterprise edition of SQL Server?

A. SQL 2008 Standard does not allow Compression on
Backup files. The database is in heavy development and
so we need frequent copies of the database for testing,
it's been a pain backing up and then zipping the .bak file.

<< I would have put that money into the hardware instead.

If you read my message, I informed you that I am currently
waiting for approval of a new Dell Raid box.

I simply asked for advice on how to use the current hardware
that I have until the new Dell box is delivered. This could take
1-2 months by the time I get approval, ordered, shipped,
installed, tested, and deployed.

Once again, using my currently limited hardware:

I will be backing up logs frequently.
I will be wanting to do full backup's.
I will be mirroring to another SQL 2008 Server.

Which drive for database?
Which drive for logfiles?
Which drive for logfile backups?
Which drive for full Backup's?
Which drive for mirroring?

Russ


"Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx> wrote in message
news:OBYv5jEFKHA.4168@xxxxxxxxxxxxxxxxxxxxxxx
Russell,

Why are you using Enterprise edition of SQL Server if you only have Std
edition of the OS and a single 1.3GB db? Unless you really need an
enterprise feature I would have put that money into the hardware instead.
In any case you have no redundancy as is if you only have 2 physical
drives with no Raid. You need to decide how important uptime and
performance is and if you want to get external disks or a larger chassis.
With such a small db and that much memory disk performance probably won't
be much of an issue but I don't know your growth patterns. But by placing
the backups on the same drive as the data or logs you risk loosing data if
one of the drives crashes since you will loose backups and either the log
or data files. Do you have a network share you can backup to? If so I
would go that approach and I would recommend doing regular Log backups
(every 15 minutes or so) to minimize any data loss instead of full backups
every 4 hours.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Russell Mangel" <russell@xxxxxxxxx> wrote in message
news:%23fxi6WEFKHA.4004@xxxxxxxxxxxxxxxxxxxxxxx
Hi,
I am running SQL Server 2008 Enterprise (64-Bit), on
Windows 2008 Standard Server (64-Bit). Lastest service
packs. The hardware isn't much, trying to get approval
for new Dell RAID box, but until then:

Can you suggest the best place for the SQL Database
file and the Log file with the hardware that I have?
Currently, the OS and SQL Server Database file and
log file are installed C: Drive. There is a single Database
(1.3GB) in use . Should I put the log files on the 2nd D:
drive and Database on C:?

I would also like to configure a Mirror with another
SQL Server 2008 Server.
And lastly I also wish to continue do Full Database
backups every 4 hours to one of the two Drives.

Would appreciate your advice.

The Hardware:
SunFire X2200 2 CPU's (4 Cores), (64-Bit) 2.4GHZ
12GB of RAM
2 physical 1TB IDE Samsung Drives C: and D:

Additional Information:
The Box does have IDE Raid 1 (Mirroring) but it's a
terrible IDE RAID from NVidia. There are no released
drivers from NVidia for Windows 2008 Server 64-Bit,
so I can't use RAID. No room for more Physical Disks,
it's only a 1U rackmount case.

Thanks

Russell Mangel
Las Vegas, NV








.

Relevant Pages

  • Re: Advice Requested : Disaster Recovery with 2 Drives (No Raid) with SQL Server 2008
    ... so we need frequent copies of the database for testing, ... Andrew J. Kelly SQL MVP ... But by placing the backups on the same drive as the data or logs you risk loosing data if one of the drives crashes since you will loose backups and either the log or data files. ...
    (microsoft.public.sqlserver.programming)
  • Re: Adding another server instance to another hard drive?
    ... A disaster recovery plan will help you minimize data loss. ... If your computer crashes and/or you lose your SQL Server drive, ... get lucky with a successful attach of the database files if your database ... > drives to actively store data. ...
    (microsoft.public.sqlserver.server)
  • Re: using sql-dmo to detach and reattach a database
    ... you really should consider standard backups. ... They're faster and your users can access the database during the backup. ... Columnist, SQL Server Professional ... Is there a way, through sql-dmo, to detach and then reattach a database from ...
    (microsoft.public.sqlserver.server)
  • Re: Advice Requested : Disaster Recovery with 2 Drives (No Raid) with SQL Server 2008
    ... As far as splitting the transaction log files and the data files, that's always a good strategy, but for a 1.3GB database... ... I am running SQL Server 2008 Enterprise, ... backups every 4 hours to one of the two Drives. ...
    (microsoft.public.sqlserver.programming)
  • Re: Database issue....
    ... Splitting data across different disks is a long-standing performance ... Senior Database Administrator ... I support the Professional Association for SQL Server ... > Is there any way that we can use two drives on a single ...
    (microsoft.public.sqlserver.clustering)
Loading