Viewing 15 posts - 511 through 525 (of 1,158 total)
None of these options are ideal which is why I would go for a custom table with settings for centralised management. Avoiding the SSIS section completely. This does...
March 8, 2012 at 5:13 am
shahuls2000 (3/7/2012)
I have to deliver a 'generic' SSIS package, that the client will make multiple copies of, deploy and schedule each copy for different source databases. I have...
March 8, 2012 at 5:11 am
Silly question, has the file finished copying when you try the restore?
What are the build numbers of the instances?
March 8, 2012 at 4:54 am
or powershell invoke-sqlcmd.
Both of these can be scheduled. Its also possible to make the file name dynamic and/or loop through multiple files in a folder.
It depends on how flexible...
March 8, 2012 at 4:51 am
The SQL server transaction and error logs are not editable. They can be "read" in a fashion but not in an easily readable form.
Worth noting that successful logins are...
March 8, 2012 at 4:50 am
There are no issues upgrading replication between versions provided the distributor is upgraded as well.
For all types of replication, the Distributor version must be no earlier than the Publisher version....
March 8, 2012 at 2:54 am
SQLKnowItAll (3/7/2012)
When you create the subscription, it wall ask you if you want to initialize after you create the subscription. Make sure to say no here.
Unless you do it...
March 8, 2012 at 2:51 am
Also worth noting that these servers werent the primary oltp servers. These are mostly scaled out servers through replication or logshipping. Most of them are load balanced so...
March 7, 2012 at 10:03 am
I'm using approx 250TB (30-40 servers) of fusion io at the moment and the performance as noted is great. Reliability not quite so. We've had occasional blue screens,...
March 7, 2012 at 10:02 am
March 4, 2012 at 7:35 am
SSIS is a different beast to DTS so if you want to know more about those internals it's likely you need to be more specific.
March 3, 2012 at 11:29 am
balasach82 (3/2/2012)
2. Are there any major differences in the way an DTS is opened...
March 3, 2012 at 11:28 am
Why would you want to?
Filegroups are used to store and group data for backup, logic, security and performance purposes. Log files dont need to be in the same position....
March 3, 2012 at 8:30 am
dilipd006 (3/1/2012)
I know it is not possible to take the DB backup from enterprise
Do you?
It is possible provided you arent using any enterprise specific features.
dilipd006 (3/1/2012)
Does sql...
March 2, 2012 at 7:50 am
Viewing 15 posts - 511 through 525 (of 1,158 total)