Printable View
One could make a DTS to export a database from one SQL Server to another SQL Server, what I want to clarify is about the size specification, if the source database has outgrown the size you specified for the destination what will happen if you will later on execute the saved DTS Package?
No quite sure what you mean by this.Quote:
Originally Posted by dee-u
Should it be
Quote:
if the source database has outgrown the size you specified for the destination what will happen?
Yap, sorry, will edit it... :blush:
Depends on how the database file growth for the destination is set. If you have specified a maximum size and the source data is larger than the maximum size, the DTS job will stop execution when the database is full. Otherwise (if using autmatic file growth) it will only stop if it runs out of disk space.Quote:
Originally Posted by dee-u
I don't have SQL Server here but I remember when one tries to copy a database from one server to another then one have to specify a size for the destination database and log file, isn't it the size being saved in the DTS?
Don't worry about that. It does not control the actual size of the destination. I tried it right now, and it sets the destination db to unrestricted file growth.Quote:
Originally Posted by dee-u
Did you specify a file size for the destination db? If I consequently run the DTS Package and the specified file size is smaller than the actual size of the souce will I not have any problem? Thank you so much for looking into this...
I didn't get an option to specify the file size in the DTS. It showed me the actual database size, but I couldn't change the size of the destination database.Quote:
Originally Posted by dee-u
What did you use? Export?
I used DTS and the Transfer database taskQuote:
Originally Posted by dee-u
Hmmmnnn... Didn't checked about that, will look into it later, thanks for the info! :afrog: