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

Online backup of SQL 2005 Express database?

Do you need to shutdown the database prior to using the 'SQL Server Management Studio Express' to backup a SQL 2005 Express database?  I would like to run a backup while in 'production' (database online) but am hesitant if there are any issues...   If no need to shutdown database, will this simpe process create a fully recoverable database?

Thanks for any insight!
0
davis
Asked:
davis
  • 2
  • 2
1 Solution
 
chapmandewCommented:
No, just run the backup as normal...

backup database dbname to disk = 'c:\backupfile.bak'

All db backups are "online"
0
 
davisAuthor Commented:
Thanks for the feedback.  One other question - is it necessary to also backup other 'built-in' databases, such as the 'master' or 'model' in order to have a fully recoverable PRIMARY database?
0
 
chapmandewCommented:
YES...for sure make full backups of master and msdb....model and tempdb are not really necessary IMO, but the first two are musts.  Just make full backups of them every night or so.
0
 
davisAuthor Commented:
Great, thank you for the assistance!
0
 
jornluxCommented:
Regarding potential 'in-production-risks' - does this apply to SQL Server 2000 aswell ?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

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