|
-
Nov 6th, 2005, 08:18 PM
#1
 DTS Clarification
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?
Last edited by dee-u; Nov 7th, 2005 at 02:12 AM.
-
Nov 7th, 2005, 02:09 AM
#2
Re: DTS Clarification
 Originally Posted by dee-u
if the source database has outgrown the size you specified for the source what will happen?
No quite sure what you mean by this.
Should it be
if the source database has outgrown the size you specified for the destination what will happen?
-
Nov 7th, 2005, 02:11 AM
#3
Re: DTS Clarification
Yap, sorry, will edit it... 
-
Nov 7th, 2005, 02:16 AM
#4
Re: DTS Clarification
Originally Posted by dee-u
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?
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.
-
Nov 7th, 2005, 02:19 AM
#5
Re: DTS Clarification
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?
-
Nov 7th, 2005, 02:27 AM
#6
Re: DTS Clarification
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.
-
Nov 7th, 2005, 02:35 AM
#7
Re: DTS Clarification
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...
-
Nov 7th, 2005, 02:38 AM
#8
Re: DTS Clarification
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.
-
Nov 7th, 2005, 02:40 AM
#9
Re: DTS Clarification
What did you use? Export?
-
Nov 7th, 2005, 03:05 AM
#10
Re: DTS Clarification
Originally Posted by dee-u
What did you use? Export?
I used DTS and the Transfer database task
-
Nov 7th, 2005, 03:12 AM
#11
Re: DTS Clarification
Hmmmnnn... Didn't checked about that, will look into it later, thanks for the info! 
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
™
Reply With Quote
