Viewing 15 posts - 661 through 675 (of 1,292 total)
You need to restore the Full backup again with norecovery option.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 7, 2009 at 4:56 pm
Discuss with the application developers to make some checks on their side, at least a few if not all.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 7, 2009 at 2:09 pm
I got the exact error message when we first setup the SQL server 2008 and I migrated the DTS Packages to SSIS.
You need to install Oracle Client component, I happened...
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 7, 2009 at 1:41 pm
Where did you get it, who asked you to perform?
Mouse Over in SQL Server 7, 2000 ??? Never heard it though, heard it from Application Developers (.NET guys)...
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 7, 2009 at 1:28 pm
Look at the web site in my signature and visit Blogs, it has a blog with steps to Deploy SSIS Packages upon Development.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 7, 2009 at 1:17 pm
Thats true Andrew, and it all begins with a well planned implementation.
But sometimes, it so happens that we have to inherit a database that has been implemented by someone...
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 7, 2009 at 1:11 pm
I just checked our Windows Server and it is 32 Bit OS.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 7, 2009 at 12:49 pm
There is not much of a time lag in Replication (Transactional Replication), so the subscribers will have the data changes (inserts, updates, deletes) in a near real time.
Regarding a suggestion,...
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 7, 2009 at 12:41 pm
I am not an Oracle expert, but have recently migrated our DTS packages from 2000 to 2008 SSIS packages.
Thought sharing some info would be helpful to you. All I had...
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 7, 2009 at 12:33 pm
Alvin Ramard (12/7/2009)
... and where's the script for the table(s) and sample data? 😛
1 more question, 32 Bit or 64 Bit System?
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 7, 2009 at 11:20 am
sureshdeenu (12/7/2009)
Hi Guys, I am trying to migrate all the sql agent jobs from 2000 to 2005, can somebody give me step by step process? thanks in adavance
Have you read...
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 7, 2009 at 11:17 am
1. Quick automatic response in case of hardware failure.
Failover Clustering will not provide HA when the hardware failure is related to your storage system.
It will only failover and...
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 7, 2009 at 10:30 am
Have you not thought about this solution --- adding additional storage space and add secondary Data Files to that Database and disabling the autogrowth of your data files residing on...
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 7, 2009 at 10:12 am
Steve Jones - Editor (12/7/2009)
OK, I couldn't resist: http://www.sqlservercentral.com/Forums/Topic829828-338-1.aspx
Steve, explanation about journey was very apt.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 7, 2009 at 9:42 am
I am sorry I missed answering the 64 bit part of the question.
There is a property called Run64BitRuntime, which can be set to false when deploying SSIS packages, which might...
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 7, 2009 at 9:21 am
Viewing 15 posts - 661 through 675 (of 1,292 total)