Post reply

Scheduling Backups

  • February 22, 2006 at 12:40 am

    #167234

    How can we schedule backups in Sql Server 2005,

    Also is there any possibility to retrieve the deleted database (there is no backup available)

  • February 22, 2006 at 2:57 am

    #622560

    1: In T-SL, sp_add_schedule and sp_attach_schedule

    2: Read your question again - if you delete the data and have no other copies...

  • February 23, 2006 at 6:31 am

    #622889

    Schedule backups - creating a maintenance plan in SSIS (SQL Server Business Intelligence Studio on the menu) might be the easiest way.

     

    MG

    "There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
    Tony Hoare

    "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.

  • February 23, 2006 at 9:45 pm

    #623111

    Can u plz ellaborate the process of making the maintenance plan, as i cant see any thing related to maintenance plan in the Business Intelligent Studio.

  • February 27, 2006 at 7:46 am

    #623435

    Open the sql server management studio and connect to your database.  Find the "management" section and open that up.  You will see maintenance plans, right click and select the wizard.   The only downside I've seen in sql 2005 is that the wizard does not allow for automatically deleting old backups.

    You have to right click and select "create new maintenance plan" to get the "cleanup old backups" functionality.  If you go this route, not using the wizard, you are basically creating a DTS package to do the maintenance ( except now it is called integration services not DTS ).

    Final note:  it appears that many of the stored procedures used in earlier versions to create jobs etc are becoming deprecated.  For example, dbcc reindex will eventually be removed and we will use the REBUILD option of the ALTER INDEX  command instead. 

    These links will show how old ways of doing things will have to be modified.

    This link is specific to feature changes that can break applications: http://msdn2.microsoft.com/en-us/library/ms143179.aspx
     
     

     

    Randy

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply