Gad SAADIA
asked on
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
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
Hi,
Are your databases backed up? How?
Regards
David
Are your databases backed up? How?
Regards
David
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
The question was intended to learn and know from other people experience with similar environement, SQL and Windows Backup
Thank you
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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?
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?
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
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
ASKER
thank you
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