• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 636
  • Last Modified:

Windows 2008 Backup and SQL Server

Hello,

I use to backup my Windows 2008 R2 SQL Server 2008 with Windows 2008 Backup on a USB external drive

Backup is done daily, and ends successfully without any error message

During backup SQL Server Service is NOT stopped and VSS is used by Windows Backup to backup SQL Server online

However I have been told that I should turn off SQL Server before backup (NET STOP MSSQLSERVER) and start it after Backup is finished (NET START MSSQLSERVER)

QUestion:

Is it necessary to turn off and on MSSQLSERVER service before and after running Windows 2008 Backup? or does VSS works fine and SQL Server can remain online?

I hope I have been clear with my English...

Thank you for your answer
0
gadsad
Asked:
gadsad
  • 3
  • 3
  • 2
  • +1
2 Solutions
 
Rob StoneCommented:
According to Microsoft you will be OK with that setup:

Ability to recover applications. Windows Server Backup uses VSS functionality that is built into applications like Microsoft® SQL Server® to protect application data.

http://technet.microsoft.com/en-us/library/cc770266%28v=ws.10%29.aspx
0
 
David ToddSenior DBACommented:
Hi,

Are your databases backed up? How?

Regards
  David
0
 
Anthony PerkinsCommented:
Here is a question for you:  Have you been able to restore any database using this method?  If the answer is yes, then you should be fine.  On the other hand (as I suspect) the answer is no (or worse you have never tried), then you are in trouble.  

Try and remember this:  Your backup is only good if you can restore from it, otherwise it is wasted disk space.
0
Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

 
gadsadAuthor Commented:
Yes I did restore sometimes database dans It works OK

The question was intended to learn and know from other people experience with similar environement, SQL and Windows Backup

Thank you
0
 
Anthony PerkinsCommented:
Typically the way it is done is by scheduling a daily full SQL Backup and if you are using Full Recovery Model you also need to set up frequent Transaction Log backups as well.  This last could range between every few hours to every 15 minutes.
0
 
David ToddSenior DBACommented:
Hi

I suggest Ola Hallegren's free script. His script creates various jobs, and all you need to do is schedule them.

Regards
  David
0
 
gadsadAuthor Commented:
What are Ola Hallegren free script? where do I find them?

Is I understand well you are suggesting to do and SQL Backup (it is a dump of the databases ?) in addition to Windows 2008 Backup.


Is that the solution?
0
 
David ToddSenior DBACommented:
Hi,

Sorry - previous comment was done via mobile.

Ola Hallengren's free script can do this for you. As in, why reinvent the wheel?
http://ola.hallengren.com/

I have Ola's script in several servers, and the solution is very stable.

HTH
  David
0
 
gadsadAuthor Commented:
thank you
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 3
  • 3
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now