database management

Peter,

As I've stated numerous times all the data is coming thru as intended, I created the database so I know its location . I am totally aware RT and + are different animals, just as Unix RT and Windows RT are different animals, I'm still using Unix on 3 machines. We run a lot of parts and I'm sure it will use up the 2 gig limit eventually, this is why I'm certain the database will need backed up and cleaned at some point. I will continue to investigate this anomaly.

Thanks

Okay so SQL2008R2 should have a 10 gig data limit, that should be the version of SQL that was installed with 5.0. I just attach to a new database on a yearly basis and back up my .MDF and .LDF files, and yes these are the actual location of stored data. Your best friends if you don't know already are "Data sources(ODBC)" which is a tool built into Windows for creating links to a database that may have been broken or exists on a remote computer so you can create a DSN (Data Source Name). Also SSMS (SQL Server Management Studio) which you can use to detach and reattach a database to a SQL server, this is a tool that needs to be downloaded from Microsoft.

My typical course of action is to create a Database on a yearly basis and back them up in a secure location but leaving them attached to the SQL server in case I need to review old data. Database size is limited but number of databases is not so you can have as many databases connected to your SQL server as you want. In DP+ I just choose which database I want to connect to and as far as sending data you will need to change the database that you output to depending on the tools you use to get data in.

4 gig is the limit for 2008, 2008R2 has is supposed to have a 10 gig limit but this will be dependent on hardware too. You can't have a 10 gig database on a machine with 4 gigs of ram or a system still using fat32 which has a 4 gig file size limit.

But yes, I just create a new database called "CompanyDatabase2017" and switch all of my data sources to the new database, if I want to see old data then I just connect to the old database in Datapage. I then shut down the SQL service and copy the file for a backup, I do not delete it and then restart SQL. (Databases cannot be moved while the SQL service is running, alternately you can use SMSS to take the database offline and then bring it back up after it's been moved)

4 gig is the limit for 2008, 2008R2 has is supposed to have a 10 gig limit but this will be dependent on hardware too. You can't have a 10 gig database on a machine with 4 gigs of ram or a system still using fat32 which has a 4 gig file size limit.

But yes, I just create a new database called "CompanyDatabase2017" and switch all of my data sources to the new database, if I want to see old data then I just connect to the old database in Datapage. I then shut down the SQL service and copy the file for a backup, I do not delete it and then restart SQL. (Databases cannot be moved while the SQL service is running, alternately you can use SMSS to take the database offline and then bring it back up after it's been moved)