Log & Data Problem While Loading Database
Tahir
I am trying to load a database from another server to my test machine.
My present database is of 20GB but on the target I am planning to
create 30GB Database. I have various segments in my source database
and I have fregmentations on the same. Multiple devices are fregmented
and I already have two devices for LOG. I have about 18GB for data on
separate devices while 2GB for Log. There is no combination of Log &
Data on any devices on my source database.
Now on my target machine, I have to create 30GB Database (10GB more
than source database) and also I have database devices of different
sizes. On source I have combinition of 2GB, 500MG, 250MB etc., but on
my target I have different sizes database devices like 2GB, 8GB, 4GB &
1GB etc.
How can I create a database on target which should not mix data with
log on database devices. The output of syssegments cannot be matched
on both the servers.
What is the remedy for that? I will appreciate help.