Forum Replies Created

Viewing 15 posts - 166 through 180 (of 860 total)

  • RE: Log Shipping Problem

    reddi_arjun (4/21/2009)

    Is there a way we can use the online restore option of SQL Server 2005 in log shipping ?

    Theres not really any option like that Log shipping is a...

    April 21, 2009 at 4:20 pm

    #981864

  • RE: Log Shipping Problem

    reddi_arjun (4/21/2009)

    Hi everyone,

    We are using Log Shipping to copy a database from Prod to reporting server.

    When the restore step happens on the secondary server all the users are disconnected. then...

    April 21, 2009 at 3:38 pm

    #981844

  • RE: "Database 'COMMON' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details."

    sharanurampur (4/21/2009)

    my database is located at D drive and it is having 22GB space,

    and mainly effected DB is common, its .mdf is 100MB and .ldf is 450MB,

    Yes, But...

    April 21, 2009 at 3:35 pm

    #981841

  • RE: Rebuild index online

    trans54 (4/20/2009)

    Hi all, if i choose to rebuild clustered index (120 GB in size) online and i choose sort_in_tempdb option how much space do i need for tempdb to be...

    April 21, 2009 at 2:58 pm

    #981822

  • RE: Mirroring Time out errors

    Imke Cronje (4/20/2009)

    My principal and standby machine has SP3 but the witness has SP2.

    Regards

    IC

    I doubt this could be due to network problems as well. How is your network health? Did...

    April 20, 2009 at 12:24 pm

    #980953

  • RE: Swings in Page Life Expectancy

    David O (4/17/2009)

    Perfmon and Diagnostic manager are both showing large swings my servers page life expectancy. It doesn't seem to be a bottleneck right now but I'd like...

    April 19, 2009 at 6:10 pm

    #980452

  • RE: Access denied

    Could you post the exact error for me please?

    April 19, 2009 at 10:40 am

    #980364

  • RE: Database Size growing so fast nearly 200GB

    Leo (4/19/2009)

    Hello,

    One of my database on Production Server which was 100GB and it grow 204GB on last weekend.

    Is it your data file or log file?

    Nobody use that server at...

    April 19, 2009 at 10:10 am

    #980357

  • RE: Effect of Truncate on Indexes

    Patelbhai (4/19/2009)

    Question:-

    What is the effect on Indexes?

    Indexes definition remain the same.And this will apply to the new records as they are added.

    Do I need to rebuild indexes on...

    April 19, 2009 at 10:03 am

    #980356

  • RE: Information on Datafile - Urgently.

    venu_ksheerasagaram (4/19/2009)

    Hi Friends,

    I am new to this Datafile topic. Can anybody pls solve my questions.

    1)Basics...

    April 19, 2009 at 5:18 am

    #980331

  • RE: Access denied

    soofy21 (4/18/2009)

    I need to move data from my test envirnoment in a MS SQL Server 2000 database to a staging envirnoment, also a MS SQL Server 2000 database. I created...

    April 19, 2009 at 5:10 am

    #980330

  • RE: Understanding execution plan

    fayilt (4/18/2009)

    I use set showplantext on to get execution plan of my query, but I feel that I am lack of theoretical knowledge about it. Where can I read about...

    April 18, 2009 at 7:42 pm

    #980296

  • RE: SQL Server 2005 Poor performance on loading

    su5y (4/18/2009)

    Hi,

    We rebooted the box a few weeks back due to bad performance and seen a great improvement in load times 10-15hrs for a few loads - over the past...

    April 18, 2009 at 7:39 pm

    #980294

  • RE: Weird Occurrence W/ Backup Job

    I would advise you to use simple maintenance plan or some standard scripts to backup your system databases rather than using the undocumented commands for critical business activities and i...

    April 18, 2009 at 12:40 pm

    #980242

  • RE: new db - transaction log file size

    lk4772 (4/17/2009)

    the dba is asking for the size of the transaction log file needed.

    No, SQL server will chose the size of the transaction log file. A dba should know...

    April 18, 2009 at 11:58 am

    #980236

Viewing 15 posts - 166 through 180 (of 860 total)