Viewing 15 posts - 451 through 465 (of 619 total)
vijaishankar.yadav (3/18/2009)
How to Mirror DB from One Server to Other
Did you actually look into this or are you just asking randomly? :doze:
Read BOL (books online), try a few bits and...
March 18, 2009 at 11:06 am
homebrew01 (3/18/2009)
Jonathan Kehayias (2/10/2009)
I ask myself that same question sometimes. Usually at 2:30am when I am driving to the office to begin a maintenance task like installing SP3 on...
March 18, 2009 at 10:58 am
Perry Whittle (12/4/2008)
its more to do with admin rights on the box, put yourself in the administrators group on the server and watch the little green arrows appear 😉
Thanks Perry,...
March 17, 2009 at 5:56 am
Ok, we can get to the certification later.
For now run the scrip below on both servers. It will create a user called 'MirrorUser' with a password of 'mirror'. I am...
March 11, 2009 at 10:58 am
Is this about a space issue or just wanating to keep the logs small?
If space issue, consider moving the logs to another disk on yout server.
If just trying to...
March 11, 2009 at 10:33 am
Hi there,
A couple of things that werent clear to me while reading:
A: are both your instances local (ie INSTANCE1 and INSTANCE2) and are they named or default?
B: Did...
March 11, 2009 at 10:22 am
Mike Levan (3/11/2009)
March 11, 2009 at 9:56 am
If your using SQL 2005 you should build these actions into a maintenance plan (SSIS based). This way you can control the flow. I.e the t-log backup wont trigger until...
March 9, 2009 at 9:53 am
How did you create the mirror? TSQL or wizard? Are you able to check with defaults ports? Has the port your using been allocated for that traffic?
March 9, 2009 at 9:47 am
How did you create the mirror? TSQL or wizard? Are you able to check with defaults ports? Has the port your using been allocated for that traffic?
March 9, 2009 at 9:47 am
krishnaraj9 (2/9/2009)
PaulB (2/9/2009)
1. While instalation i am getting one error "restart ur system and install again" ?
Server liked the process that much...
February 10, 2009 at 2:48 am
PaulB (2/9/2009)
1. While instalation i am getting one error "restart ur system and install again" ?
Server liked the process that much it...
February 9, 2009 at 9:53 am
Mike Levan (1/29/2009)
Cannot add rows to sysdepends for the current object because it depends on the missing object 'sp_hexadecimal'. The object will still be created.
Cannot add rows to sysdepends for...
January 30, 2009 at 2:23 am
Mike Levan (1/27/2009)
still doesnt work to pull user list from AD.
Sorry guess yoou do need the NOT, try this, have tested and works 😉
USE [master]
GO
/****** Object: StoredProcedure [dbo].[sp_help_revlogin_specific_name] ...
January 28, 2009 at 2:15 am
Sounds like your about there. Gave you the script to be easier (if your new to this, less to explain), wasnt being patronising.
One thing though, if a user has DBO...
January 27, 2009 at 9:01 am
Viewing 15 posts - 451 through 465 (of 619 total)