Viewing 15 posts - 226 through 240 (of 420 total)
In your case you'll want to use the STOPAT flag with the full restore, not the log restore.
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
June 23, 2008 at 11:56 am
Take a look at what I said above. Here, I'll paste it in here so you know what I'm talking about.
The short answer to that specific scenario is I...
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
June 23, 2008 at 10:03 am
I don't really have any insight into the office team. I'm on office'07 though and it appears to be buggy there too. However, I'm not sure if it's...
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
June 23, 2008 at 9:52 am
I've got a video I did last week on working with for each loops. Give me till tomorrow and I'll post it for you.
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
June 23, 2008 at 9:49 am
OK, now maybe I'm not explaining myself clearly either. Try what I told you to and get back to us.
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
June 23, 2008 at 9:43 am
Well there's evidently something really screwy in the driver because I not only recreated your problem, I was able to introduce new problems.
However, I was able to do...
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
June 23, 2008 at 9:41 am
The short answer to that specific scenario is I don't know. I could honestly see it going either way. However, you're talking about recovering a specific transaction, so...
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
June 23, 2008 at 9:20 am
Well, it really depends on the mode that the DB was in when you ran the delete.
You may have screwed yourself with the log backup though. If...
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
June 23, 2008 at 9:05 am
We don't really have an equivalent to that function. If the values already exist in the data you're importing then assign varchar on the target. If not, then...
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
June 23, 2008 at 9:01 am
Sorry dude, this is not an IBM forum. I would suggest trying one of those. You may have better luck.
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
June 23, 2008 at 8:58 am
There's no difference between the 2 platforms so you shouldn't be having this issue as a result of being on 64bit.
And if you're positive that you've got it setup for...
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
June 20, 2008 at 9:09 am
I'm not sure, but my initial thought is no.
However, the easiest way to get it done is to have the child save the new value to a table and just...
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
June 20, 2008 at 8:55 am
Somewhat, but their exact permissions aren't self-explanatory.
For instance, it's not a given what the difference between serveradmin and sysadmin is. That's not in the names of either...
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
June 20, 2008 at 8:51 am
I can't imagine why you'd be doing it like this anyway. The ways you were forced to do things in DTS aren't the ways you'd choose to do them...
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
June 20, 2008 at 8:47 am
Yeah, the documentation inside sql itslef is lacking to the level of disappointment.
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
June 20, 2008 at 8:36 am
Viewing 15 posts - 226 through 240 (of 420 total)