Forum Replies Created

Viewing 15 posts - 6,016 through 6,030 (of 9,253 total)

  • RE: Restore SQL 2000 DB in SQL 2005

    ssa2010 (2/7/2012)


    friends,

    If any problems when restore sql 2000 db in sql 2005

    and

    ...

  • RE: Database copy for reporting

    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...

  • RE: Mirroring issue

    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]

  • RE: Mirroring issue

    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

  • RE: Mirroring issue

    saidapurs (2/7/2012)


    5): Mirroring655362642TCP4 DATABASE_MIRRORING0STARTED03ALL13NEGOTIATE01RC4.

    Which instance is this result set from?

  • RE: Mirroring issue

    Have you created and configured the mirroring endpoint on the witness instance?

    How are you adding the witness, via the GUI or T-SQL?

  • RE: insufficient memory

    sqlfriends (2/6/2012)


    I got it, thanks all

    Great, set the max memory and post back if you need any further help

  • RE: insufficient memory

    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)


    I guess it means in SQL server...

  • RE: insufficient memory

    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....

  • RE: Transaction Log file size issue

    rajg (2/6/2012)


    But my problem at this moment is - log file has is very large and recently it created problem. Last friday - it automatically increased the size since autogrowth...

  • RE: ignoring duplication on uppercase and lowercase value.. help

    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...

  • RE: ignoring duplication on uppercase and lowercase value.. help

    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...

  • RE: How many IP address include in 2 node active -passive cluster

    Shivrudra (1/17/2012)


    Hi,

    How many IP address include in 2 node active -passive cluster .....

    i answered Five ........2 for private network

    ...

  • RE: 3GB PAE in windows 2008 32 bit?

    ananda.murugesan (2/4/2012)


    also running other application symantec Endpoint Protection, it is scanning on weekly one time basis, and daily basis LTO Backup running on night time. could you confirm 1GB memory...

Viewing 15 posts - 6,016 through 6,030 (of 9,253 total)