| Author |
 Topic  |
|
|
Pesos
Honorable But Hopeless Addict
USA
3504 Posts
Status: offline |
 Posted - 08/02/2012 : 10:50:21 PM
|
We have a sharepoint 2010 server that we will be hosting for a client. We are responsible only for the server hosting and data backups - no configuration. I am hoping to get this as "set it and forget it" as possible.
As this is a hyper-v guest, assuming we do a periodic backup of the VHD file will this, in conjunction with regular SQL backups, suffice as a backup strategy? The server itself should not be changing at all, correct - only the dB? We would backup the VHD again following windows/sharepoint updates (will avoid the latter like the plague most likely).
I have set a 10 GB limit on the content DB for now (will keep an eye on it for a while to gauge growth). Any other tips/ideas would be most welcome!
|
-Wes |
|
|
chamezzzz
Honorable But Hopeless Addict
United Kingdom
2297 Posts
Status: offline |
Posted - 08/03/2012 : 09:15:21 AM
|
Hi Wes,
Short answer, in theory yes.
I take it there is only one application server in the farm.
The sharepoint databases reside on the SQL server and the SharePoint is on the WIN 2008 box?
It would be good to know the SP configuration, for your own peace of mind.
I deleted a wrong snapshot on my sharepoint application server once and re-building the app server and pointing to the databases is nowhere near as easy as you think it will be.
I have not looked at the backup options in 2010 but they look much better than 2007 which was all set spn command line *fury*
This gent appears to have a nice overview
http://blogs.msdn.com/b/russmax/archive/2009/10/21/sharepoint-2010-granular-backup-restore-part-1.aspx
|
James |
 |
|
|
Pesos
Honorable But Hopeless Addict
USA
3504 Posts
Status: offline |
Posted - 08/03/2012 : 10:01:51 AM
|
| It is all one box. It was originally installed thinking it would be a POC box so we did a standalone installation which installed SQL 2008 express. Now that I realize their intention is to take this box right into production, I've gone ahead and upgraded the SQL express instance to a standard 2008 r2 instance - that went smoothly enough. But it is all still contained on one box. I'd like to move the DBs to the D drive I created, but that process looks to be a bit hairier than I have time for right now... |
-Wes |
|
|
|
chamezzzz
Honorable But Hopeless Addict
United Kingdom
2297 Posts
Status: offline |
Posted - 08/03/2012 : 10:54:03 AM
|
In which case, I think you will be OK.
It would be nice to know the configuration, it just takes one ham fisted admin to change a setting and it all come crashing down. |
James |
|
|
|
Curt
Moderator
USA
6648 Posts
Status: offline |
Posted - 08/03/2012 : 11:27:33 AM
|
You will have to watch it.
Had a really heafty SQL server crash this week at a VAR.
Seems like your on the right track but remember the SQL server is not a water heater. Run a SQL profile on the SQL server and check the frequent routines that are run simply by having Share Point running.
quote:
Originally posted by Pesos
We have a sharepoint 2010 server that we will be hosting for a client. We are responsible only for the server hosting and data backups - no configuration. I am hoping to get this as "set it and forget it" as possible.
As this is a hyper-v guest, assuming we do a periodic backup of the VHD file will this, in conjunction with regular SQL backups, suffice as a backup strategy? The server itself should not be changing at all, correct - only the dB? We would backup the VHD again following windows/sharepoint updates (will avoid the latter like the plague most likely).
I have set a 10 GB limit on the content DB for now (will keep an eye on it for a while to gauge growth). Any other tips/ideas would be most welcome!
|
Curt Spanburgh
Microsoft Certified Business Solution Specialist.
Dynamics CRM MVP
Contributing Editor, Windows IT Pro
He that is walking with wise persons will become wise, but he that is having dealings with the stupid ones will fare badly.
Proverbs 13:20
|
|
|
|
Pesos
Honorable But Hopeless Addict
USA
3504 Posts
Status: offline |
|
| |
Topic |
|
Sharepoint backup and general mgmt tips
