Jump to content

Search the Community

Showing results for tags 'backup'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Essentials
    • Announcements
  • Passwordstate 8.x
    • General Support
    • Feature Requests
    • Feature Requests - Completed
    • Known Issues
    • Installing Passwordstate
  • Knowledge Base
    • General FAQs
    • Password Resets
    • Remote Session Launcher
    • Mobile Client
    • Passwordstate API
    • Browser Extensions
    • Password Reset Portal
  • Passwordstate 7.x
    • General Support
    • Known Issues

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


AIM


MSN


Website URL


ICQ


Yahoo


Jabber


Skype


Google Plus Account


Location


Interests


Biography


Location


Interests


Occupation

Found 3 results

  1. Here at Click Studios we frequently do testing of certain features, and we use a handy script to quickly restore your database. We thought we'd share this script with our community which can help speed up testing. An example when we use this script is we are writing an API script to import bulk passwords into the system, but we did something wrong in our script and it imported a whole bunch of incorrect data for what ever reason. We then decide to roll back the database to the state it was in just prior to running the script, and then test our API script again until we get it right. Running the script below only takes a few seconds and although there are other ways to do this, we find this is the quickest way. How to Use? Run the following SQL scripts with SQL Management Studio Tools, when connected to your database server. SQL Script 1 - Backup your database as a once off process just prior to performing your testing ------------------------------------------------------------------------------------------------------------------------------------- -- Database Backup ------------------------------------------------------------------------------------------------------------------------------------- USE passwordstate DECLARE @BackupSQLScript nvarchar(max) DECLARE @DatabaseName sysname DECLARE @SQLBackupFileName nvarchar(400) DECLARE @SQLBackupFolder nvarchar(400) SET @DatabaseName = db_name() --DB name is current DB of user (better than hard coding in case you change DB name in future versions) SET @SQLBackupFileName = 'passwordstate\' + @DatabaseName + '.bak' SET @BackupSQLScript = ' BACKUP DATABASE [' + @DatabaseName + '] TO DISK = ''' + @SQLBackupFileName + ''' WITH FORMAT' EXEC sp_executesql @BackupSQLScript SQL Script 2 - Run this script to revert your database to the state your database was in just before you started testing, ie roll back to the backup performed in SQL Script 1, above. Repeat this as necessary USE passwordstate DECLARE @BackupSQLScript nvarchar(max) DECLARE @DatabaseName sysname DECLARE @SQLBackupFileName nvarchar(400) DECLARE @SQLBackupFolder nvarchar(400) SET @DatabaseName = db_name() --DB name is current DB of user (better than hard coding in case you change DB name in future versions) SET @SQLBackupFileName = 'passwordstate\' + @DatabaseName + '.bak' SET @BackupSQLScript = ' BACKUP DATABASE [' + @DatabaseName + '] TO DISK = ''' + @SQLBackupFileName + ''' WITH FORMAT' ------------------------------------------------------------------------------------------------------------------------------------- -- Take the Database Offline ------------------------------------------------------------------------------------------------------------------------------------- -- Step 1: Retrive the Logical file name of the database from backup ALTER DATABASE [passwordstate] SET OFFLINE WITH ROLLBACK IMMEDIATE ------------------------------------------------------------------------------------------------------------------------------------- -- Restore Database ------------------------------------------------------------------------------------------------------------------------------------- RESTORE DATABASE passwordstate FROM DISK = @SQLBackupFileName WITH NOUNLOAD, REPLACE, STATS = 5 We hope this helps:) Support
  2. SadSaddo

    Restore from backup

    Hi, I have just set up the automated backup system that comes with PasswordState however it is unclear how I would be able to restore from backup. As a test I wanted to restore a backup to check if it works properly but I can't find the feature anywhere. How would one do this?
  3. I want to describe my experience when upgrading Passwordstate from a clean (first time) installation Versions: Current Build: Version 6.3 (Build 6350) New Build: Version 7.0 (Build 7033) Note: I am running Passwordstate on a server, that is not connected to a domain/AD. I had a fair bit of trouble with this, probably mostly due to the fact I am new to passwordstate, so I thought I would document for any other readers running into the same problem. My issue were primarily with getting the backup working. Here's what I did: I put in my userinfo and backup path to a shared folder on our server ( i.e. C:\<folder name>\ ) and I put in credentials for an administrator account and hit the "test settings" button. Nothing was happening, and I never got any error message. So I tried starting the upgrade process via the notification in the top of the passwordstate webapp, and I got the following error: Upgrade error detected - Index was outside the bounds of the array. - Method = StopWindowsServiceButton_Click What I did to solve this was: First change my account name from <account> to .\<account> (since I'm using a local account and not an AD account) Add permissions for the account "NT services\MSSQLSERVER" account: right click your chosen backup folder, select properties > security tab > hit Edit... button > click Add... > type in NT services\MSSQLSERVER > select MSSQLSERVER from the list > click OK After completing these two steps, I was able to succesfully test backup settings and get going with the upgrade. Regards, Gazhak
×