search

dubeaud / bugnet

BugNET is an open source issue tracker built with .NET
189 stars 166 forks source link

How to make a backup of the database #147

Closed topcatarg closed 8 years ago

topcatarg commented 9 years ago

Hello. We are trying to set up a nice daily backup of our database. is there a standard procedure to do that? We try opening the db inside SSMS but is exclusive taken by bugnet. Is that correct?

dubeaud commented 9 years ago

You may be running it in user instance mode, if you attach the database you can then backup via ssms.

topcatarg commented 9 years ago

You say SSMS? we have to open it using the same user that bugnet is using? we are opening SSMS using the sa user. is not that the correct one?

dubeaud commented 9 years ago

Using SA is perfectly fine. Just recycle IIS or shut it off to unlock the database then attach it in SMSS.

topcatarg commented 9 years ago

ok, will try that tomorrow.. Will that afect bugnet operation? Or I have to deatach after the backup. I would like to make a daily backup, auto.