Viewing 15 posts - 8,221 through 8,235 (of 9,720 total)
mahesh.vsp (10/27/2009)
Data Transformation services.
My question is , i dont have any dts packages created pointing to my application database.
Still it is...
October 27, 2009 at 4:19 am
The Upgrade Advisor should NOT be run the day of your migration. It should be run at least a week *before* your migration (several weeks, if possible). If the Upgrade...
October 27, 2009 at 4:14 am
GilaMonster (10/26/2009)DBCC UpdateUsage and sp_updatestats do completely different things. Are you thinking of UPDATE STATISTICS vs sp_updatestats?
I plead the "Monday Mornings" as my excuse.
Yes, that's what I meant. DOH!...
October 26, 2009 at 6:59 am
Neither really is better than the other. The issue with Detach / Attach, though, is if you forget to make a copy of your files, you can never "roll back"...
October 26, 2009 at 6:58 am
I knew I forgot something. The stats update. VERY IMPORTANT when upgrading from SQL 2000 to either 2k5 or 2k8.
Thanks for the reminder, Gail.
ravikanth - Reasons why you don't want...
October 26, 2009 at 4:58 am
I haven't done migration to 2008 yet. However, from what I understand, the engine hasn't changed very much and 2008 supposedly allows a direct upgrade from 2000.
Look into Microsoft's SQL...
October 23, 2009 at 7:27 am
Cool! Glad you figured it out. @=)
October 22, 2009 at 3:50 am
I run into the same problem with SSIS when I have a schema definition mismatch. I'd advise checking that first. Make sure to check not only structure but (if applicable)...
October 22, 2009 at 3:48 am
Thanks for posting your solution. That's a nice document.
So are you going to force the actual xml file to include the those entity references instead of the < and =...
October 21, 2009 at 8:12 am
I'm assuming "flat" means that the XML is all on one line with no pretty carriage returns between each data element. Sort of like:
<column1>2adfad</column1><column2>adfeoue</column2><column3>etouen</column3>
If that's not what the OP means...
October 21, 2009 at 6:50 am
Have you tried right-click to see if a menu with a script option pops up?
SSIS in 2005 supposedly allows for the migration of jobs, logins and maintenance stuff, but I've...
October 21, 2009 at 6:47 am
I have to agree with Ian here. Replication is not meant as a disaster recovery tool. It's meant to keep data synchronized between separate offices such as bookstores or airlines.
Log...
October 21, 2009 at 5:47 am
BTW, have you looked into Data Mirroring? That might stand you in better stead.
What about passive / active clustering with RAID 5 or RAID 10? That is probably the easiest...
October 21, 2009 at 4:51 am
Regarding #1, Server A becomes the backup once it becomes available again. Don't try to transfer. It's too much work. Just re-snapshot the database(s) in question and restart Replication using...
October 21, 2009 at 4:47 am
A few things to remember:
Make a checklist. -- We can't give you a specific one because it depends on how your server is setup. The checklist should include EVERYTHING...
October 21, 2009 at 4:42 am
Viewing 15 posts - 8,221 through 8,235 (of 9,720 total)