August 12, 2004 at 9:18 am
HI All,
I work for a county agency. I have several sites that have seperate databases they connect to on the same server. The issue I am having is transferring records between the databases. Right now they close one record in one database and re-enter the data at the new. As you can imagine it creates alot of duplicate records with different ID's.
I would like to merge these into one database. I have created a new database and am going to restore a back up of the 1st database to start with. I will then use transact sql scripts to merge the other databases in. The issue is with the 1st database having multiple log files. How can I merge, or remove the multiple log files so the initial databse i am restoring has only one log file?
Also is there a better way to approach what I am trying to accomplish?
Any help would be appreciated.
Rsissons
August 12, 2004 at 12:46 pm
I don't think you'll get around the multiple log files issue using a restore. You'll either need to use your scripts to load the initial db as well, or what may be easier, use DTS to import the data.
Steve
August 12, 2004 at 3:29 pm
From your description it sounds like you have your work cut out for you...but if you want to get rid of the extra log file, you can simply delete it as long as it doesn't contain any active or non-truncated virtual log files.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply