Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 597
  • 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

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

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