Viewing 15 posts - 166 through 180 (of 1,065 total)
Ninja's_RGR'us (3/18/2011)
No he's actually really smart, and he never had problems with "his" stuff. Hence my "what if" has very little weight.
Sound as if a little "accident" with his...
March 18, 2011 at 10:07 am
Ninja's_RGR'us (3/18/2011)
admin doesn't want to take tlog during the day because he feels it can't possibly break
No need to take ANY backups then 😀
I agree with the others... the extra...
March 18, 2011 at 9:22 am
Are you trying to run the query against the default SQL instance on the server?
You aren't specifying the -S parameter to OSQL. From BOL:-
If no server is specified, osql connects...
March 18, 2011 at 9:08 am
Have a look at the properties of the login you are using to connect to the two servers... I suspect the default language for the login on one server will...
March 18, 2011 at 5:22 am
You aren't really giving anybody much to go on.
Even a bit of sample data would help, along with what you are trying to achieve and some expected results.
The error...
March 18, 2011 at 3:42 am
DUMP isn't an "option" or a "version", it won't make your backup file backwards compatible. It is nothing other than the keyword of the command used to backup the database...
March 18, 2011 at 2:39 am
"MainEngineThread is returning 1620" means the Windows installer couldn't open the MSI file.
This could just be a corruption of your original download or disc.
March 17, 2011 at 3:19 am
I would strongly advise against doing this in a trigger.
What would happen if the other server was unavailable? Would you want your original update to fail as well, or...
March 14, 2011 at 4:25 am
DBA - Does Bu**er All
as some of my co-workers try to tell me 😛
March 11, 2011 at 4:58 am
kp81 (3/11/2011)
Nice one mate, much MUCH appreciated!
My pleasure, and thanks for the feedback.
March 11, 2011 at 4:47 am
Nice post Kev... complete with all you need to provide a tested solution.
The creation of your test data may be what is stopping you from coming up with the solution...
March 11, 2011 at 4:01 am
I've had to do this a few times, and couldn't find any tools to help (I haven't looked recently, so there may be some now).
In the end I wrote a...
March 11, 2011 at 3:28 am
Jeff Moden (3/5/2011)
March 6, 2011 at 10:45 am
You've probably got this covered, but just in case...going back to your original post, you said
After restoring the days full backup (with NORECOVERY), and then restoring a DIFF backup (FULL...
March 4, 2011 at 2:20 pm
jcrawf02 (3/4/2011)
Greg Edwards-268690 (3/4/2011)
Tough course to take online, when the only feedback you get is correct or incorrect.
The...
March 4, 2011 at 8:06 am
Viewing 15 posts - 166 through 180 (of 1,065 total)