Viewing 15 posts - 2,206 through 2,220 (of 4,272 total)
Phil Parkin (5/4/2010)
After backing up on server 1 you'll need to transfer the file to server 2 before it is restored. I...
May 4, 2010 at 11:12 am
Step 1. I'm not talking about using the transfer objects at all, Step 1 is a backup and restore, which can be be in an SSIS package.
Step 4. when...
May 4, 2010 at 11:10 am
Good question Phil.
CEWII
May 4, 2010 at 10:32 am
Ok, 300M is nothing, even 5-10GB is really not all that big in my opinion.
Your concern over sensitive data is good. I see a couple options, both of which...
May 4, 2010 at 10:31 am
If I understand your requirement this will probably generate a script that can be run to create the relationships you are wanting:
SELECT '--Cmd' = 'ALTER TABLE dbo.'
...
May 4, 2010 at 10:11 am
First I want to stop using the term replication, the reason is that it implies some things that aren't in play. In SQL Server there are several types of...
May 4, 2010 at 10:01 am
Ok, then I think I am starting to see the problem..
Also I'm not recommending a For loop.
It sounds like the recordset being passed into the F-E-L contains too many records....
May 4, 2010 at 9:47 am
I'm not 100% sure but I think SSIS will only use assemblies that are installed in the GAC. I'm willing to bet that the DLL's you are looking for...
May 4, 2010 at 9:35 am
Lowell,
Perhaps I read that a little differently than you did, I thought he was talking about foreign keys, if he was talking about views then my advice doesn't apply..
CEWII
May 4, 2010 at 9:32 am
I think you are getting the cart before the horse. Install SQL. Also, what user is DTC using to login, I believe the right answer should be NT...
May 4, 2010 at 9:26 am
Are the tables all similar or do they have the same key structure? If so then a script could be generated to do it. But if we are...
May 4, 2010 at 9:17 am
For the initial copy I would probably just do a backup/restore. For the others I would probably build SSIS packages to copy the data back and forth. The...
May 4, 2010 at 9:16 am
I'm confused.
How many records are in the ADO Recordset that the Foreach Loop containter is iterating through? If it is 18 then the container will execute its...
May 4, 2010 at 9:09 am
Is the DTC in the same resource group as the SQL Server and its log is on a disk in that resource group?
CEWII
May 4, 2010 at 1:52 am
Duplicate post, please reply to http://www.sqlservercentral.com/Forums/Topic913573-391-1.aspx
CEWII
May 4, 2010 at 1:50 am
Viewing 15 posts - 2,206 through 2,220 (of 4,272 total)