Forum Replies Created

Viewing 15 posts - 7,366 through 7,380 (of 9,244 total)

  • RE: Database Mirroring Setup Failure.

    Sourav-657741 (11/28/2010)


    The login 'NT AUTHORITY\NETWORK SERVICE' does not have CONNECT permission on the endpoint. State 84.'.

    The message above seems fairly descriptive, can you provide more details as to the...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Does the size of the model database increase automatically?

    has someone created objects inside Model by any chance?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Single command to rebuild all the indexes of all the tables

    Joy Smith San (11/27/2010)


    It's a 185 GB database and defragmentation is not done since long time it seems. Heavily fragmented it is.

    With this size database, as Gail says, I...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Moving a SQL 2008/Windows 2008 cluster to a new domain

    personally I would deploy a new cluster into the new domain and migrate everything across.

    Is the new domain a child in the same forest as the current domain or...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Logins from SQL 2000 to SQL 2008

    shaun.stuart (11/24/2010)


    Interesting. For me, using sp_help_revlogins did not work going from 2000 to 2008.. But then, I was actually going from 2008 to 2008 R2. Still, it didn't work for...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: How to find out what is truncating a database transaction log

    Patricia Johnson (11/22/2010)


    Thanks. I thought about that as well and didn't have any additional steps in the sql agent jobs. The transaction log backups of all the databases...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Partition Table Switch Error


    The table 'GBR_Test.dbo.CDR_0_test' has clustered index 'GBR_CDR_0_Test_IX_Xharging_TimeStamp_Partition' while the table 'GBR_Test.dbo.CDR_0_Test_Part' does not have clustered index.

    ?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: How to find out what is truncating a database transaction log

    Patricia

    check for a SQL Server agent job that executes against the Insight database and contains a step that manually truncates the log. I had this issue previously with another application...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Mirror from cluster with dedicated NIC

    What operating system are you using on the cluster nodes and the stand alone server?

    Is the stand alone server completely stand alone or is it a member of the same...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: can't delete old back up file created by sql server 20005.

    Best to stop the job really so it releases locks. Go into Computer Management and view open files there.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Running SQL Server 2008 with Local Admin or Domain user

    this is already in discussion at the link posted by LutzM

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Running SQL Server 2008 with Local Admin or Domain user

    Ok, thats undoubtedly part of the issue. You must use SQL Server configuration manager to change the service user account\password credentials!

    Note: Local system will automatically have full rights to...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Running SQL Server 2008 with Local Admin or Domain user

    ocolakoglu (11/21/2010)


    We have change the sql server startup user from domain account to local system

    how are you changing the user account for the sql server service?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: can't delete old back up file created by sql server 20005.

    have you checked the net backup job status?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Change the seed value of an existing table

    Sp_help shows you the default which looks like it's using the default (1, 1). This happens if you do not supply values during the creation phase. Design the table in...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 15 posts - 7,366 through 7,380 (of 9,244 total)