Forum Replies Created

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

  • RE: How to schedule a SQL FULL backup WITH COPY_ONLY

    In SQL Server 2008 you can do copy only backup with GUI and you can script it as T-SQL, then creating the Maintenance Plan for schedule with that T-SQL.

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    January 14, 2010 at 2:08 pm

    #1103946

  • RE: How to schedule a SQL FULL backup WITH COPY_ONLY

    Jeffrey Williams-493691 (1/14/2010)

    Dugi (1/14/2010)

    Copy Only Backup with SSMS are supported just in SQL Server 2008!

    http://msdn.microsoft.com/en-us/library/ms187510.aspx

    Wrong - COPY_ONLY is not available when using the GUI in SSMS 2005, however - you...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    January 14, 2010 at 2:04 pm

    #1103941

  • RE: How to schedule a SQL FULL backup WITH COPY_ONLY

    I really don't know why he or they want to do copy only backup with SSMS with schedule, for that reason if really they want to do it they can...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    January 14, 2010 at 2:03 pm

    #1103939

  • RE: Copy table with index and statistics

    Krasavita (1/14/2010)

    Copy table with index and statistics,is anyone knows how I can copy table with indexes and statistics with another name

    ...also with no data...any reason why do you need that!?

    copying...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    January 14, 2010 at 1:50 pm

    #1103927

  • RE: How to schedule a SQL FULL backup WITH COPY_ONLY

    xxdbxx (1/14/2010)

    Correct. The thread-starter did not mention versions and since they seemed to know what copy - only backups were I assumed they were on SQL 2008.

    db

    I understand...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    January 14, 2010 at 11:33 am

    #1103816

  • RE: Copy table with index and statistics

    Krasavita (1/14/2010)

    Copy table with index and statistics,is anyone knows how I can copy table with indexes and statistics with another name

    Maybe it can be done with other alternatives, but the...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    January 14, 2010 at 10:54 am

    #1103788

  • RE: How to schedule a SQL FULL backup WITH COPY_ONLY

    Copy Only Backup with SSMS are supported just in SQL Server 2008!

    http://msdn.microsoft.com/en-us/library/ms187510.aspx

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    January 14, 2010 at 10:45 am

    #1103783

  • RE: How to schedule a SQL FULL backup WITH COPY_ONLY

    xxdbxx (1/14/2010)

    You can definitely create a job within SSMS to run a piece of SQL code which could be a Copy Only Backup.

    And I really have no idea...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    January 14, 2010 at 10:40 am

    #1103781

  • RE: How to schedule a SQL FULL backup WITH COPY_ONLY

    I think that with SSMS you cannot do it as schedule!

    You should create PowerShell script that will stop the SQL Server services, copy files from folder to other folder, then...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    January 14, 2010 at 9:57 am

    #1103749

  • RE: Only Configuration Manager Installs

    S Hodkinson (1/12/2010)

    Installation is complete. The workstation element is now on and all working correctly.

    Thanks

    So the problem solved with re-installation or anything else!?

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    January 12, 2010 at 8:33 am

    #1102475

  • RE: Identity column limitation

    A composite column is a violation of 1st normal form

    As DBA I agree, as developer I cannot understand the developers, why they allow these things during the large Database design!?!...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    January 12, 2010 at 8:10 am

    #1102455

  • RE: Modify column causes "tables will be saved" warning

    homebrew01 (1/12/2010)

    When making changes with the GUI (table changes, backup, restore, jobs ...), before you click the final "OK", you can script out the change that's about to be made....

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    January 12, 2010 at 8:00 am

    #1102443

  • RE: Modify column causes "tables will be saved" warning

    Example:

    You have table TEST and one of the columns that you want to change is LASTNAME NVARCHAR(50) and you want to change it to NVARCHAR(100), you will do like this

    ALTER...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    January 12, 2010 at 7:56 am

    #1102438

  • RE: Identity column limitation

    GilaMonster (1/12/2010)

    Dugi (1/12/2010)

    I said before that large and medium DBs have tables that the Identity Col has generated value with combination, and the last value can be sequence number that...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    January 12, 2010 at 7:41 am

    #1102423

  • RE: Modify column causes "tables will be saved" warning

    You can do it with T-SQL like:

    ALTER TABLE YourTable

    ALTER COLUMN YourColumn Datatype(new size)

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    January 12, 2010 at 7:33 am

    #1102416

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