I have 2 databases and am inserting data (millions of records) from one database to another to create ONE large database. All the fields, schema of the databases are identical.
I have limited space on my server, and note this database will not be appended after the creation. It will be a static database and users will be retrieving and reading the data ONLY.
Now, on the insertion the log files grew for the last table as it had (176 million records) - So I went to Tasks - Shrink - Files and selected log file (then optioned for Release Unused Space) - This brought the log file down (it had built to 80 GB).
Question1. Is the above practice OK since the database will not be appended in future and users will ONLY access the data as it is? Will this mess up my database?
Question 2. Before I append the data from one database to another - I copied all the data from the table (e.g., dbo.company to dbo.companycpy) and then did the append procedure to dbo.company - the reason I make a copy is as a fall safe in case I corrupt the table. Then when I complete the append I go back to the database and delete the table (dbo.companycpy) - this practice in return has resulted to the growth of the mdf file. How can I restore the used space without interfering with the data or database structure? I read people writing of index fragmentation which is really making me concerned.
Any suggestions how I can take this forward will be highly appreciated.