nicholab Posted October 15, 2015 Posted October 15, 2015 How do you store your password for you SIMS backup using dbattach? Is there an easy way of storing the password securely?
matt40k Posted October 15, 2015 Posted October 15, 2015 What? In the command-line? Well if its via Attix5\RBUSS\RedStor - its encrypted. If its via a batch file or such, then well, you've saved it to the C:, which only administrators who can log on can access - ie the folks who can reset it. Or do you mean, hey I've got this really complex password, how do I store it - keepass, lastpass, printed bit of paper in the school safe - key is more then one secure place.
nicholab Posted October 15, 2015 Author Posted October 15, 2015 Bad practice storing password in batch files although that what the Sims support have done.
matt40k Posted October 15, 2015 Posted October 15, 2015 Mmm, not ideal, i'll admit, but again, if we're talking about a secure location on a server... Ideally you could use windows authentication, though i've never tried to be honest with dbattach. Should work ok tho, check with your sims support - don't want it reverting back or conflicting with the one they setup or whatever
nicholab Posted October 16, 2015 Author Posted October 16, 2015 Could you user powershell to launch dbattach passing the details? As I know you can use a secure string in powershell.
vikpaw Posted October 19, 2015 Posted October 19, 2015 I prefer a management plan in SQL to do the backups.
Greg Posted October 19, 2015 Posted October 19, 2015 You use the /TRUSTED switch for dbAttach Run dbAttach.exe /? for all details /TRUSTED - Used instead of /USER and /PASSWORD. Uses the current Windows Logon. User must have been setup in System Manager. For DBAttach version 1.8 /TRUSTED can only be used for /BACKUP without /PATH. 1
nicholab Posted October 20, 2015 Author Posted October 20, 2015 Does this work for as Scheduled task? How do you setup a management plan and how well does it work?
vikpaw Posted October 21, 2015 Posted October 21, 2015 If you have SQL Management Studio, There is a tab for Maintenance Plans. You can create a new one, drag and drop a backup widget I think onto the screen. Configure the Databases to backup, location to save and a schedule. It's nice and fairly straight forward. You must make sure that whatever backup strategy you use, it is the only one, or that whatever you use is compatible. What I like about the plan is it's built-in, runs itself so long as the sql agent is running, and I have added extra workflow that I get emails on Failure and Success. The resultant .bak file can be easily restored This is just my method, you may find you prefer something else.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now