Good morning!

Quick question - in an SBS2003 SP2 Premium environment we have a need to
back up the SQL Database and then restore it.

The client has no backup software (such as Backup Exec) other than NTBackup.

Does this even work? I know very very well that NTBackup is Exchange-aware.
I use NTBackup to backup EXCH2003 and EXCH2007 quite successfully. I see
"Microsoft Information Store" as one of the "things" to backup. I do not
see anything for SQL in NTBackup. This pretty much tells me that NTBackup
is not SQL-aware.

How would I - in this situation - backup SQL2000? More importantly, how
would I restore it?

Thanks,

Cary

PS. Client is never going to purchase backup software. We have to make it
work with what we have.

Cary Shultz <cshultz@nospam.outsourceitcorp.com> wrote:
> Good morning!
>
> Quick question - in an SBS2003 SP2 Premium environment we have a need
> to back up the SQL Database and then restore it.
>
> The client has no backup software (such as Backup Exec) other than
> NTBackup.
> Does this even work? I know very very well that NTBackup is
> Exchange-aware. I use NTBackup to backup EXCH2003 and EXCH2007 quite
> successfully. I see "Microsoft Information Store" as one of the
> "things" to backup. I do not see anything for SQL in NTBackup. This
> pretty much tells me that NTBackup is not SQL-aware.
>
> How would I - in this situation - backup SQL2000? More importantly,
> how would I restore it?
>
> Thanks,
>
> Cary
>
> PS. Client is never going to purchase backup software. We have to
> make it work with what we have.

I don't know how SBSBackup and VSS handle this, but NTBackup itself doesn't
have a SQL agent (and for your purposes here you don't need one). You can
run a manual or scheduled backup in SQL Enterprise Manager. I'd set up a
maintenance plan for all your databases to do this regularly to a folder on
the local hard drive(s) of the server itself - tell it to keep the last 5
backup files or something. But you can also do this manually on an as needed
basis.

What Lanwench says! Best schedule SQL Backup far enough in advance of SBS
Backup so that the SQL bkf files will be included in the daily NTBackup.
Example: SQL Backup 9pm SBS Backup 11PM

--
Frank McCallister SBS MVP
MCP Microsoft Small Business Specialist
COMPUMAC

"Cary Shultz" <cshultz@nospam.outsourceitcorp.com> wrote in message
news:#MADI9PuIHA.576@TK2MSFTNGP05.phx.gbl...
> Good morning!
>
> Quick question - in an SBS2003 SP2 Premium environment we have a need to
> back up the SQL Database and then restore it.
>
> The client has no backup software (such as Backup Exec) other than
> NTBackup.
>
> Does this even work? I know very very well that NTBackup is
> Exchange-aware. I use NTBackup to backup EXCH2003 and EXCH2007 quite
> successfully. I see "Microsoft Information Store" as one of the "things"
> to backup. I do not see anything for SQL in NTBackup. This pretty much
> tells me that NTBackup is not SQL-aware.
>
> How would I - in this situation - backup SQL2000? More importantly, how
> would I restore it?
>
> Thanks,
>
> Cary
>
> PS. Client is never going to purchase backup software. We have to make
> it work with what we have.
>

Lanwench,

Perfect answer. Exactly the answer I was looking for. Thanks!

Cary

"Lanwench [MVP - Exchange]"
<lanwench@heybuddy.donotsendme.unsolicitedmailatya hoo.com> wrote in message
news:%23uGLuJQuIHA.548@TK2MSFTNGP06.phx.gbl...
> Cary Shultz <cshultz@nospam.outsourceitcorp.com> wrote:
>> Good morning!
>>
>> Quick question - in an SBS2003 SP2 Premium environment we have a need
>> to back up the SQL Database and then restore it.
>>
>> The client has no backup software (such as Backup Exec) other than
>> NTBackup.
>> Does this even work? I know very very well that NTBackup is
>> Exchange-aware. I use NTBackup to backup EXCH2003 and EXCH2007 quite
>> successfully. I see "Microsoft Information Store" as one of the
>> "things" to backup. I do not see anything for SQL in NTBackup. This
>> pretty much tells me that NTBackup is not SQL-aware.
>>
>> How would I - in this situation - backup SQL2000? More importantly,
>> how would I restore it?
>>
>> Thanks,
>>
>> Cary
>>
>> PS. Client is never going to purchase backup software. We have to
>> make it work with what we have.
>
> I don't know how SBSBackup and VSS handle this, but NTBackup itself
> doesn't have a SQL agent (and for your purposes here you don't need one).
> You can run a manual or scheduled backup in SQL Enterprise Manager. I'd
> set up a maintenance plan for all your databases to do this regularly to a
> folder on the local hard drive(s) of the server itself - tell it to keep
> the last 5 backup files or something. But you can also do this manually on
> an as needed basis.
>

Cary Shultz <cshultz@nospam.outsourceitcorp.com> wrote:
> Lanwench,
>
> Perfect answer. Exactly the answer I was looking for. Thanks!
>
> Cary

Glad it ed....

>
> "Lanwench [MVP - Exchange]"
> <lanwench@heybuddy.donotsendme.unsolicitedmailatya hoo.com> wrote in
> message news:%23uGLuJQuIHA.548@TK2MSFTNGP06.phx.gbl...
>> Cary Shultz <cshultz@nospam.outsourceitcorp.com> wrote:
>>> Good morning!
>>>
>>> Quick question - in an SBS2003 SP2 Premium environment we have a
>>> need to back up the SQL Database and then restore it.
>>>
>>> The client has no backup software (such as Backup Exec) other than
>>> NTBackup.
>>> Does this even work? I know very very well that NTBackup is
>>> Exchange-aware. I use NTBackup to backup EXCH2003 and EXCH2007 quite
>>> successfully. I see "Microsoft Information Store" as one of the
>>> "things" to backup. I do not see anything for SQL in NTBackup. This
>>> pretty much tells me that NTBackup is not SQL-aware.
>>>
>>> How would I - in this situation - backup SQL2000? More importantly,
>>> how would I restore it?
>>>
>>> Thanks,
>>>
>>> Cary
>>>
>>> PS. Client is never going to purchase backup software. We have to
>>> make it work with what we have.
>>
>> I don't know how SBSBackup and VSS handle this, but NTBackup itself
>> doesn't have a SQL agent (and for your purposes here you don't need
>> one). You can run a manual or scheduled backup in SQL Enterprise
>> Manager. I'd set up a maintenance plan for all your databases to do
>> this regularly to a folder on the local hard drive(s) of the server
>> itself - tell it to keep the last 5 backup files or something. But
>> you can also do this manually on an as needed basis.

Frank,

Sorry! Did not mean to leave you our of the Thanks!

And, the Maintenance Plan is working very well. Has been for months.
Backing up the DB (some 5GB) takes only some seven minutes (including the
verify). The transaction logs take just a couple of minutes.

So, this whole thing is done inside of 15 minutes and the directory
structure is then included in the SBSBackup scheme.

Thanks!

Cary
"Frank McCallister SBS MVP" <anonymous> wrote in message
news:41B34188-573D-42C3-BB97-29125F1BB77B@microsoft.com...
> What Lanwench says! Best schedule SQL Backup far enough in advance of SBS
> Backup so that the SQL bkf files will be included in the daily NTBackup.
> Example: SQL Backup 9pm SBS Backup 11PM
>
> --
> Frank McCallister SBS MVP
> MCP Microsoft Small Business Specialist
> COMPUMAC
>
> "Cary Shultz" <cshultz@nospam.outsourceitcorp.com> wrote in message
> news:#MADI9PuIHA.576@TK2MSFTNGP05.phx.gbl...
>> Good morning!
>>
>> Quick question - in an SBS2003 SP2 Premium environment we have a need to
>> back up the SQL Database and then restore it.
>>
>> The client has no backup software (such as Backup Exec) other than
>> NTBackup.
>>
>> Does this even work? I know very very well that NTBackup is
>> Exchange-aware. I use NTBackup to backup EXCH2003 and EXCH2007 quite
>> successfully. I see "Microsoft Information Store" as one of the "things"
>> to backup. I do not see anything for SQL in NTBackup. This pretty much
>> tells me that NTBackup is not SQL-aware.
>>
>> How would I - in this situation - backup SQL2000? More importantly, how
>> would I restore it?
>>
>> Thanks,
>>
>> Cary
>>
>> PS. Client is never going to purchase backup software. We have to make
>> it work with what we have.
>>