Forum Replies Created

Viewing 15 posts - 46 through 60 (of 82 total)

  • RE: Database Mirroring login attempt by user 'domain\SQLLogin' failed

    I have also granted permission to that login also.

    GRANT CONNECT ON ENDPOINT::MirroringEndPoint TO [domain\MySQLAdmin]

    ______________________________________________________________Every Problem has a Solution; Every Solution has a Problem: 🙂

    June 19, 2014 at 10:52 pm

    #1723459

  • RE: BUFFER POOL EXTENSION EDITIONS

    Buffer pool Extn is not available in BI edition..

    http://msdn.microsoft.com/en-us/library/cc645993(v=sql.120).aspx

    ______________________________________________________________Every Problem has a Solution; Every Solution has a Problem: 🙂

    May 8, 2014 at 1:36 am

    #1711768

  • RE: Need to generate Report from a Busy Database

    We have mirroring on another server and a snapshot as part of high availability. Snapshot is taken every 12 hours. But snapshot takes more physical reads than the production database....

    ______________________________________________________________Every Problem has a Solution; Every Solution has a Problem: 🙂

    April 23, 2014 at 5:28 am

    #1708046

  • RE: Need to generate Report from a Busy Database

    Pls find my reply..

    Does the report have to run during business hours? - Yes

    Can the report be scheduled to run outside of hours? - No, because the end users...

    ______________________________________________________________Every Problem has a Solution; Every Solution has a Problem: 🙂

    April 23, 2014 at 1:39 am

    #1707972

  • RE: Syntax Validation

    how is it different from Ctrl+F5 which does the same parsing as NOEXEC does?? pls correct me if am wrong.

    ______________________________________________________________Every Problem has a Solution; Every Solution has a Problem: 🙂

    April 9, 2014 at 5:35 am

    #1704450

  • RE: DTS - Transferred Rows mismatch but not exactly

    If you these two sentences in the report, the number of rows differ by huge margin. Actually the number of rows in second line is the correct one. My question...

    ______________________________________________________________Every Problem has a Solution; Every Solution has a Problem: 🙂

    March 20, 2014 at 10:51 pm

    #1698940

  • RE: intersect

    Yes Adi!! it was perfect!! thank you for your worthy contribution..

    ______________________________________________________________Every Problem has a Solution; Every Solution has a Problem: 🙂

    March 19, 2014 at 4:54 am

    #1698307

  • RE: intersect

    as early as possible.. since its EOD today we have 12+ hrs 🙂

    ______________________________________________________________Every Problem has a Solution; Every Solution has a Problem: 🙂

    March 18, 2014 at 8:00 am

    #1698021

  • RE: intersect

    I have come up till this.. here I have hard coded the values of i. if this result is arrived dynamically or looping using any other logic it will be...

    ______________________________________________________________Every Problem has a Solution; Every Solution has a Problem: 🙂

    March 18, 2014 at 7:54 am

    #1698015

  • RE: sql server 2008 R2 backup version 10.50.2500 is not restoring in 10.50.4000

    I copied the file from other part of the world using TeraCopy.exe. Though the file size in bytes is same, the SQL command says its incomplete. Need to find other...

    ______________________________________________________________Every Problem has a Solution; Every Solution has a Problem: 🙂

    March 18, 2014 at 1:04 am

    #1697876

  • RE: sql server 2008 R2 backup version 10.50.2500 is not restoring in 10.50.4000

    Hi all.. sorry for the inconvenience.. the backup file is been corrupted. just find using Restore Headeronly..

    thanks!!

    ______________________________________________________________Every Problem has a Solution; Every Solution has a Problem: 🙂

    March 18, 2014 at 12:36 am

    #1697866

  • RE: sql server 2008 R2 backup version 10.50.2500 is not restoring in 10.50.4000

    Msg 3241, Level 16, State 13, Line 1

    The media family on device 'F:\DB backup\backup_2014_03_07_220436_4816312.bak' is incorrectly formed. SQL Server cannot process this media family.

    Msg 3013, Level 16, State 1, Line...

    ______________________________________________________________Every Problem has a Solution; Every Solution has a Problem: 🙂

    March 18, 2014 at 12:31 am

    #1697865

  • RE: sql server 2008 R2 backup version 10.50.2500 is not restoring in 10.50.4000

    here it is..

    ______________________________________________________________Every Problem has a Solution; Every Solution has a Problem: 🙂

    March 18, 2014 at 12:26 am

    #1697863

  • RE: sql server 2008 R2 backup version 10.50.2500 is not restoring in 10.50.4000

    am not able select the backup file.. pls check the attached screeshot.

    ______________________________________________________________Every Problem has a Solution; Every Solution has a Problem: 🙂

    March 18, 2014 at 12:24 am

    #1697862

  • RE: sql server 2008 R2 backup version 10.50.2500 is not restoring in 10.50.4000

    its not any of the system database.. its one of the user database

    ______________________________________________________________Every Problem has a Solution; Every Solution has a Problem: 🙂

    March 18, 2014 at 12:05 am

    #1697856

Viewing 15 posts - 46 through 60 (of 82 total)