Viewing 15 posts - 6,016 through 6,030 (of 9,253 total)
ssa2010 (2/7/2012)
If any problems when restore sql 2000 db in sql 2005
and
...
February 7, 2012 at 6:28 am
You're pretty much limited with your current config. SQL Server 2008 R2 Express edition may be one way of overcoming this. There's no log shipping or mirroring but you'll certainly...
February 7, 2012 at 6:22 am
saidapurs (2/7/2012)
Hi Perry,I am getting same error...
Thanks & Regards
Satish Saidapur
You're getting an error running the following against your witness instance?????
select * from sys.database_mirroring_endpoints[/Code]
February 7, 2012 at 4:26 am
saidapurs (2/7/2012)
Hi,All updates from PRIMARY instance......
Thanks & Regards
Satish
Execute the query you were given against the witness instance and post back the results
February 7, 2012 at 3:27 am
saidapurs (2/7/2012)
5): Mirroring655362642TCP4 DATABASE_MIRRORING0STARTED03ALL13NEGOTIATE01RC4.
Which instance is this result set from?
February 7, 2012 at 1:34 am
Have you created and configured the mirroring endpoint on the witness instance?
How are you adding the witness, via the GUI or T-SQL?
February 7, 2012 at 12:06 am
sqlfriends (2/6/2012)
I got it, thanks all
Great, set the max memory and post back if you need any further help
February 6, 2012 at 3:20 pm
sqlfriends (2/6/2012)
Does it mean SQL server itself (buffer pool) has not enough memory, or it means OS doesnot have enough memory?
No it doesn't
sqlfriends (2/6/2012)
February 6, 2012 at 2:47 pm
sqlfriends (2/6/2012)
[The first thing that you need to do is set the max server memory to a sensible value that will ensure SQL does not try to starve the OS....
February 6, 2012 at 1:34 pm
rajg (2/6/2012)
February 6, 2012 at 1:05 pm
Case sensitivity is not the way to go. Based on the data provided the OP would only be able to insert 2 duplicate records, what if they want to insert...
February 6, 2012 at 9:07 am
duplicate
February 6, 2012 at 9:06 am
The PK constraint across the airline_cd column will require unique values. You could drop the PK constraint, but I think you would be better off designing the table and it's...
February 6, 2012 at 5:06 am
Shivrudra (1/17/2012)
How many IP address include in 2 node active -passive cluster .....
i answered Five ........2 for private network
...
February 5, 2012 at 9:33 am
ananda.murugesan (2/4/2012)
February 5, 2012 at 3:34 am
Viewing 15 posts - 6,016 through 6,030 (of 9,253 total)