Mark McDonald 
Australia
Member since
5/20/2005
Registered Users
Posts: 9
 |
| 8/28/2005 01:50 AM |
|
Hi all,
I am just wondering if anyone out has restored a SQL database using the
inbuilt SBS Backup. I am not in a bind but simply looking for
feedback here.
thanks muchly
Mark
|
|
|
|
|
|
Richard Fagen
Canada
Member since
5/26/2005
Registered Users
Posts: 139
|
| 9/02/2005 05:24 PM |
|
HI,
I'm not sure you can. I just posted a message about that. I
suspect you must still need to use DB maintenance plans to create BAK
files of the SQL databases. I'm curious why this isn't mentioned
anywhere. From the web sites I've seen, it appears NTBackup does
everything. Maybe I'm missing something but I don't see how to
get a BKF file from SBS to restore a SQL database.
Let me know if you can do it 
Richard
|
|
|
|
|
|
Marina Roos
The Netherlands
Member since
3/24/2005
Forum Admins
Posts: 12627
|
| 9/04/2005 02:55 AM |
|
Hi Mark,
If you are using the SBS backup wizard, you can restore the whole server without a problem. It does backup Exchange, SQL and the whole thing if you haven't excluded it specifically. I only exclude folders with some install programs and logfiles from a backup, everything else get backed up. |
|
| Marina Roos Smallbizserver.Net Administrator | Mission accomplished. We have joined the branch office to our SBS 2003 Headquarters and have the same user experience on the branch office as we have on our local network at the Headquarters. Want to know how? Signup up for a subscription and get instant access to the article series 'How to add an additional Domain Controller from a remote office to the SBS domain' |
|
|
|
|
Richard Fagen
Canada
Member since
5/26/2005
Registered Users
Posts: 139
|
| 9/04/2005 05:02 PM |
|
Hi Marina,
That sounds amazing. If that's the case, I can greatly simplify all the backup jobs I was running.
When you say if does SQL, does this mean one no longer has to run the 'data maintenance plans' that optimize, reorganize and check data intergrity? IOW, will SBS backup do all this for us too?
Thanks
Richard
p.s. I think it would be a great idea to add a paragraph to the SBS backup page to explicity mention Exchange and SQL are included. |
|
|
|
|
|
Marina Roos
The Netherlands
Member since
3/24/2005
Forum Admins
Posts: 12627
|
| 9/04/2005 05:39 PM |
|
Hi Richard,
A 'Disaster Restore' means a disaster restore, which includes everything, thus also Exchange and SQL. This method can also be used to migrate to different hardware in some cases, although that will need some additional steps because of the new hardware. Read that document again please, as it also includes pages with separate or alternative ways to restore different items.
SBS Backup doesn't optimize SQL databases, it only backs them up and restores them if needed. If you need special SQL maintenance, you will have to do that manually. |
|
| Marina Roos Smallbizserver.Net Administrator | Mission accomplished. We have joined the branch office to our SBS 2003 Headquarters and have the same user experience on the branch office as we have on our local network at the Headquarters. Want to know how? Signup up for a subscription and get instant access to the article series 'How to add an additional Domain Controller from a remote office to the SBS domain' |
|
|
|
|
Richard Fagen
Canada
Member since
5/26/2005
Registered Users
Posts: 139
|
| 9/04/2005 07:24 PM |
|
Hi Marina,
You are right. When I re-read it I now noticed the addtional
links. There are many other great articles there. Wow, I
don't know how you find the time to create all this great information.
You even have great articles showing step by step how to recover Exchange mailboxes and Sharepoint info.
While I haven't played with Sharepoint yet, I believe it is stored in a
SQL database so I guess restoring SQL databases would follow a similar
procedure as outlined in Sharepoint. (I just want to doublecheck
with the experts)
I will continue to use the SQL DB maintenance plan, but I can run that
once a week (optimize, check intergrity, etc) on the weekends.
For daily jobs, I will have just the one SBS complete backup.
Thanks for the help
Richard
p.s. As you are also working Sundays, I see where you find the
time. It's supposed to be Labour Day Weekend where workers take
time off
|
|
|
|
|
|
Marina Roos
The Netherlands
Member since
3/24/2005
Forum Admins
Posts: 12627
|
| 9/04/2005 08:09 PM |
|
Hi Richard,
Personally, I don't care if it is Sunday, in the middle of the night or a Bank Holiday if a client needs me. The Labour Day is only valid in the USA, so all other people simply have to go to work tomorrow. And participating in the forum and helping getting these articles put together, isn't paid work at all. Mariette started this website years ago and is still responsible for the majority of the articles and completely responsible for the design. That also is non-paid of course. |
|
| Marina Roos Smallbizserver.Net Administrator | Mission accomplished. We have joined the branch office to our SBS 2003 Headquarters and have the same user experience on the branch office as we have on our local network at the Headquarters. Want to know how? Signup up for a subscription and get instant access to the article series 'How to add an additional Domain Controller from a remote office to the SBS domain' |
|
|
|
|
Richard Fagen
Canada
Member since
5/26/2005
Registered Users
Posts: 139
|
| 9/06/2005 07:47 PM |
|
Hi Marina,
>Personally, I don't care if it is Sunday, in the middle of the night or a Bank Holiday if a client needs me. I'm the same way. Sometimes it gets in the way of family plans, but that's life. I am lucky as I enjoy my job so I don't mind the extra hours I always put in too. >The Labour Day is only valid in the USA FYI, Canadians have Labour Day too, only we spell it with a "U" >isn't paid work at all. Mariette started this website years ago and is still responsible for the majority of the articles and completely responsible for the design. That also is non-paid of course. Your work it very much appreciated by so many people. Thanks! Keep up the great work! Richard |
|
|
|
|
|