08-30-2010 03:31 AM
I know this question has appeared many times before, but I still couldn't find a good answer.
How can LabVIEW create-/connect to-/insert data to- a new data base runtime, when the old one is full (>10GB) and nobody is around to create a new data base manually using Windows tools?
08-30-2010 05:12 AM
08-30-2010 06:16 AM
I'm using Microsoft SQL Server 2008 R2 with LabVIEW connectivity toolset.
Thank you for your answer, at least now I know where to look for a solution. I'll dig a little deeper in the Microsoft SQL server documentation.
08-30-2010 06:58 AM - edited 08-30-2010 07:00 AM
The simplist ways are usually the best. What I have done is to have an empty database stored on the machine and do a simple copy/re-name of the empty to the next active one. It's much easier then trying to create a new one on the fly. Of course you would need to do something with the orginal before copying the empty one. I use local Access files and this may not apply to your situation (but it may be of help to others).
09-30-2010 02:41 PM
I'm a little confused why this is necessary. In my many years of SQL Server admin, I have never seen a need for this.
SQL Server databases can grow well beyond 10 GB. By default, database are created to grow automatically when the datafiles reach a certain point... they don't need to "fill up". However, if you really wanted to prevent your DB from growng too big, I would prefer to build in some kind of routine for exporting old data and shrinking the database automatically, rather than creating a new empty database.