Viewing 15 posts - 76 through 90 (of 120 total)
I'm working on getting the make and model of the drive to see if it is even usb 2.0. For now I'm just using it for backups that are like...
Even as a mother protects with her life
Her child, her only child,
So with a boundless heart
Should one cherish all living beings;
June 16, 2010 at 10:00 am
LOL. I thought it sounded off. But that is what was delivered when I told our IT guy that we might have better performance if we moved our transaction logs...
Even as a mother protects with her life
Her child, her only child,
So with a boundless heart
Should one cherish all living beings;
June 16, 2010 at 9:34 am
Please provide more details about your Maintenance Plan.
Is your SQL Server Agent Running prior to starting the creation of your maintenance plan?
Even as a mother protects with her life
Her child, her only child,
So with a boundless heart
Should one cherish all living beings;
June 16, 2010 at 8:57 am
Is it possible to post that document somwhere on this site?
Even as a mother protects with her life
Her child, her only child,
So with a boundless heart
Should one cherish all living beings;
June 16, 2010 at 8:40 am
I'll take a guess ... If you right-click on your database and select properties (in Enterprise manager) and then select the Transaction Log tab. Does location point to the previous...
Even as a mother protects with her life
Her child, her only child,
So with a boundless heart
Should one cherish all living beings;
June 16, 2010 at 8:36 am
She didn't elaborate on what the issue was. I'm back in the Office on Monday and will ask her though. I'll get back to this thread when I find out...
Even as a mother protects with her life
Her child, her only child,
So with a boundless heart
Should one cherish all living beings;
June 3, 2010 at 6:59 pm
Actually the person I sent the 2000 mdf and ldf too said that the db attached fine to their 2000 and 2005 instance but wouldn't attach to their 2008. ...
Even as a mother protects with her life
Her child, her only child,
So with a boundless heart
Should one cherish all living beings;
June 3, 2010 at 5:51 am
Thanks GilaMonster! I got er done!
Even as a mother protects with her life
Her child, her only child,
So with a boundless heart
Should one cherish all living beings;
June 1, 2010 at 10:19 am
I should also mention that the reason I'm doing this is because someone added columns to the 2000 production tables and the 2008 version doesn't have those columns. Sp when...
Even as a mother protects with her life
Her child, her only child,
So with a boundless heart
Should one cherish all living beings;
June 1, 2010 at 9:57 am
Thanks for clearing that up for me. I get it now. I'll give it a whirl.
Even as a mother protects with her life
Her child, her only child,
So with a boundless heart
Should one cherish all living beings;
May 29, 2010 at 4:14 pm
That sounds like it is a pretty bad deal and I sympathize with you. If you've been using it for a couple years you prolly have alot of data. Someone...
Even as a mother protects with her life
Her child, her only child,
So with a boundless heart
Should one cherish all living beings;
May 29, 2010 at 4:12 pm
Thanks for your reply. Your solution looks more efficient than mine but I I'm not sure about the second half:
update TableA
set ID=NewID
from TableA join #TempTableA on ID=oldID
Am...
Even as a mother protects with her life
Her child, her only child,
So with a boundless heart
Should one cherish all living beings;
May 29, 2010 at 12:52 pm
I think I might have a solution. SQL works best with sets but I don't see how to avoid looping through a table to accomplish this. If you can think...
Even as a mother protects with her life
Her child, her only child,
So with a boundless heart
Should one cherish all living beings;
May 29, 2010 at 10:21 am
Hi Turkan,
Are you using third party software? If so i would contact the manufacturer. It sounds like the issue is with the software and not the DB. I mean if...
Even as a mother protects with her life
Her child, her only child,
So with a boundless heart
Should one cherish all living beings;
May 29, 2010 at 7:55 am
That's a great article! And the one prior to it specifies the steps required to do the work. Thanks for pointing that!
Even as a mother protects with her life
Her child, her only child,
So with a boundless heart
Should one cherish all living beings;
January 27, 2010 at 9:52 am
Viewing 15 posts - 76 through 90 (of 120 total)