Forum Replies Created

Viewing 15 posts - 196 through 210 (of 220 total)

  • RE: Adding a new column to a table. Best approach

    GilaMonster (11/17/2012)

    bugg (11/17/2012)

    I must ask though why does SSMS throw an error saying you should drop and recreate? Unless you uncheck the 'prevent saving changes that require a table recreate"?...

    November 17, 2012 at 12:03 pm

    #1560031

  • RE: Automated Database Restore script for Reporting DB

    bugg (11/17/2012)

    sanket kokane (11/16/2012)

    bugg (11/16/2012)

    Cheers I Have used the with restore, and changed from

    SET SINGLE_USER WITH

    ROLLBACK IMMEDIATE

    TO

    ALTER DATABASE Test_DB SET OFFLINE WITH ROLLBACK IMMEDIATE

    Do you think this will suffice?

    No ,database...

    November 17, 2012 at 10:49 am

    #1560015

  • RE: Adding a new column to a table. Best approach

    PaulB-TheOneAndOnly (11/17/2012)

    bugg (11/17/2012)

    The standard way to add a new column to a table is more or less the following.

    alter table table_name add column column_name...

    That is NOT "more or less"...

    November 17, 2012 at 10:34 am

    #1560014

  • RE: Automated Database Restore script for Reporting DB

    sanket kokane (11/16/2012)

    bugg (11/16/2012)

    Cheers I Have used the with restore, and changed from

    SET SINGLE_USER WITH

    ROLLBACK IMMEDIATE

    TO

    ALTER DATABASE Test_DB SET OFFLINE WITH ROLLBACK IMMEDIATE

    Do you think this will suffice?

    No ,database will...

    November 17, 2012 at 6:30 am

    #1559999

  • RE: Automated Database Restore script for Reporting DB

    Cheers I Have used the with restore, and changed from

    SET SINGLE_USER WITH

    ROLLBACK IMMEDIATE

    TO

    ALTER DATABASE Test_DB SET OFFLINE WITH ROLLBACK IMMEDIATE

    Do you think this will suffice?

    November 16, 2012 at 9:05 am

    #1559845

  • RE: Automated Database Restore script for Reporting DB

    I will Recommend you to go through this topic.

    http://www.sqlservercentral.com/Forums/Topic1063979-1237-1.aspx

    EDIT : Forgot to put URL

    Thanks , I've had a read through and may use the kill script, I changed my code...

    November 16, 2012 at 5:53 am

    #1559756

  • RE: Automated Database Restore script for Reporting DB

    sanket kokane (11/16/2012)

    --Drop previous reporting database

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

    PRINT 'Check if DB exists if so drop'

    GO

    IF EXISTS(SELECT * FROM SYS.DATABASES WHERE NAME='ReportDB')

    BEGIN

    --Remove any connections

    ALTER DATABASE ReportDB

    SET SINGLE_USER WITH

    ROLLBACK IMMEDIATE

    --Drop DB

    DROP DATABASE ReportDB

    END

    GO

    setting db...

    November 16, 2012 at 5:34 am

    #1559746

  • RE: Table and Column naming convention

    Luis Cazares (11/15/2012)

    The "." is not part of the table name, it's the schema name.

    You could check the Stairway for Database Design, it can give you an introduction to a...

    November 15, 2012 at 2:00 pm

    #1559528

  • RE: Database Restore

    Heres a copy of the script ideally i would like to create parameters for the folder locations of Data and Log file paths

    ALTER PROC [dbo].[restoreDB]

    @p_strDBNameTo SYSNAME,

    ...

    November 15, 2012 at 7:37 am

    #1559359

  • RE: Reporting Database

    AndrewSQLDBA (11/14/2012)

    What I would consider, is after taking a full backup at anytime, and restoring that to the other box. Then, I would create a Differential backup on an everyday...

    November 14, 2012 at 3:40 pm

    #1559165

  • RE: Reporting Database

    capnhector (11/14/2012)

    We perform a nightly backup and restore to our standby server. the way we answered the "How long till i move it?" was to set up the backup...

    November 14, 2012 at 3:34 pm

    #1559159

  • RE: Should I become a DBA?!?

    Many thanks for all your comments they are much appreciated! This thread has been a wealth of knowledge for me. I have a lot to learn and although it feels...

    October 25, 2012 at 2:41 am

    #1552557

  • RE: Should I become a DBA?!?

    jcrawf02 (10/19/2012)

    buy a copy of DBA Survivor, its straight-forward, funny and practical for someone like yourself who is just getting started.

    then, as Gail pointed out, you don't have anyone to...

    October 19, 2012 at 8:42 am

    #1550902

  • RE: Should I become a DBA?!?

    SQLRNNR (10/18/2012)

    GilaMonster (10/15/2012)

    bugg (10/15/2012)

    The company said i would be on call 24/7

    On call 24/7 on your own? That pretty much means no vacations, never out of touch, laptop with...

    October 18, 2012 at 9:48 am

    #1550575

  • RE: Should I become a DBA?!?

    Brandie Tarvin (10/18/2012)

    Honestly, it doesn't matter what you think it will be. It matters what they expect. That's why we keep telling you to talk to them.

    If you don't...

    October 18, 2012 at 7:56 am

    #1550505

Viewing 15 posts - 196 through 210 (of 220 total)