I'm running Storage Monitor on a workstation, with the default database type. What's the best way to back up the databases?

If I just copy them without stopping the service, I assume there's a risk the copies will be corrupt. Is there a way to copy them safely without stopping the service?

If I change the database location from on this PC to an SQL Server database so that it can be backed up with our other databases, will it copy all my data, or will it start with empty tables?

asked 27 Jan '16, 21:25

pshute's gravatar image

pshute
2624
accept rate: 16%


Hi pshute,

You are correct that if you want to back up the default database you will need to stop the service. In most cases that's not an option.

If you change your database from the default DB to SQL Server DB then you will be able to take advantage of using the options built into the SQL Server to do regular backups.

Moving from the default database is easy and yes y ou can have you data moved as well. Sometimes moving the data can take a while. There is more information in our documentation on Database Settings.

Thanks
Quinn

Please make sure to mark your questions accepted when you have your answer by clicking the gray check mark to the left of the answer.

link

answered 28 Jan '16, 13:07

Quinn's gravatar image

Quinn ♦♦
14.4k3925
accept rate: 35%

Thanks. Now what happens if I want to put it all back how it was? Can I reverse the process?

link

answered 28 Jan '16, 13:22

pshute's gravatar image

pshute
2624
accept rate: 16%

I guess I don't understand... Why would you want to switch back to the default database?

(29 Jan '16, 09:55) Quinn ♦♦

Why would I want to switch back? I hope I wouldn't, I'm just thinking about what I'd do if things don't work out.

link

answered 29 Jan '16, 15:06

pshute's gravatar image

pshute
2624
accept rate: 16%

Yes, you can switch back the default database. The service will also give you the option to copy the data from your SQL Server to the default Database.

Thanks
Quinn

Please make sure to mark your questions accepted when you have your answer by clicking the gray check mark to the left of the answer.

link

answered 01 Feb '16, 09:00

Quinn's gravatar image

Quinn ♦♦
14.4k3925
accept rate: 35%

Thanks, last question (I think) - is there any way to estimate how much room the data will consume if I move it to SQL Server? I'm concerned that I might run our main SQL Server out of disk space, which would be ironic considering the purpose of Storage Monitor.

Perhaps I should install SQL Server Express locally first to try it. I assume it's possible to move the data from there to another SQL Server later?

link

answered 02 Feb '16, 15:51

pshute's gravatar image

pshute
2624
accept rate: 16%

That's a conman question. We aren't able to give you a answer to how much disk space your going to need. There are too many variables that will change the space needed, such as number of monitors, how often they scan, how long you keep the data, how data you are scanning.

Your idea to try on the SQL Server Express on your local machine would be a great start.

Thanks
Quinn

Please make sure to mark your questions accepted when you have your answer by clicking the gray check mark to the left of the answer.

link

answered 03 Feb '16, 09:33

Quinn's gravatar image

Quinn ♦♦
14.4k3925
accept rate: 35%

What I meant, Quinn, was can I make a guess at the disk space from the size of the existing SQLite database files?

link

answered 03 Feb '16, 15:06

pshute's gravatar image

pshute
2624
accept rate: 16%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×22
×3
×3

Asked: 27 Jan '16, 21:25

Seen: 9,411 times

Last updated: 03 Feb '16, 15:06