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

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.

Well it is still a lot cheaper to buy one of the 3rd party backup compression utilities such as Red-gate for a few hundred dollars than to pay for a EE license, especially if it is a per processor license. There is no problem with what you have I was just trying to save you money.

I still think your best option is to backup to a networked share but if you insist on backing up locally with what you have now I would do the following:

Which drive for database?
Drive D:
Which drive for logfiles?
Drive C:
Which drive for logfile backups?
Drive D:
Which drive for full Backup's?
Drive C:
Which drive for mirroring?
Mirroring doesn't require an extra drive, can you be more specific?

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Russell Mangel" <russell@xxxxxxxxx> wrote in message news:uAP9S4EFKHA.1336@xxxxxxxxxxxxxxxxxxxxxxx
<<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, ... Which drive for logfile backups? ... Why are you using Enterprise edition of SQL Server if you only have Std ... drives with no Raid. ...
    (microsoft.public.sqlserver.programming)
  • Re: New install of SBS and where to put SQL and exchange
    ... One thing to add about partitions though - shadow copy also has a bearing on ... database drives so those should be separate from user data which you do want ... SBS is one busy machine, exchange and sql, are ... drives with a multi-channel RAID controller? ...
    (microsoft.public.windows.server.sbs)
  • Proper way to move Log files to another drive
    ... For speed, I have separate drives for OS, SWAP, APPS, SQL, and LOGS. ... the APPS drive, and it created its database, and log file, in the default ...
    (microsoft.public.sqlserver.setup)
  • Re: Mapped Drive
    ... SQL does not support mapped drives for database or transaction log ... I support the Professional Association for SQL Server ...
    (microsoft.public.sqlserver.server)
  • Split Mirror backup and restores
    ... We are implementing Veritas Volumn Manager 4.0 on a Windows 2003 server ... We will using the flashsnap plugin to do full database ... backups and using SQL to do transactional log backups. ...
    (microsoft.public.sqlserver.server)
Loading