RE: SQL Server Restore

From: Fany Vargas [MSFT] (fanyv_at_online.microsoft.com)
Date: 11/20/04

  • Next message: Fany Vargas [MSFT]: "RE: installing hotfix SQL2000-KB810185-8.00.0780-ENU"
    Date: Sat, 20 Nov 2004 09:14:36 GMT
    
    

    Hi Raj, do you mean you are rebuilding the master database - using
    rebuildm? If so then ensure you have a backup of you master,msdb,and model
    databases. you will need to restore these system databases if you want to
    get back your logins,jobs,etc.

    For instructions on how to restore system databases see KB: INF: Moving SQL
    Server 7.0 Databases to a New Server with BACKUP and - ID: 304692
    (available at http://support.micrososft.com).

    Fany Vargas
    Microsoft Corporation
    This posting is provided "AS IS" with no warranties, and confers no rights.

    Are you secure? For information about the Strategic Technology Protection
    Program and to order your FREE Security Tool Kit, please visit
    http://www.microsoft.com/security.

    Microsoft highly recommends that users with Internet access update their
    Microsoft software to better protect against viruses and security
    vulnerabilities. The easiest way to do this is to visit the following
    websites:
    http://www.microsoft.com/protect
    http://www.microsoft.com/security/guidance/default.mspx


  • Next message: Fany Vargas [MSFT]: "RE: installing hotfix SQL2000-KB810185-8.00.0780-ENU"

    Relevant Pages

    • Re: Database Maintenance Plan Problems
      ... the system databases such ... Deleted by Maintenance Plan ... >>A maintenance plan job to backup transaction logs ... >>Backup can not be performed on this database. ...
      (microsoft.public.sqlserver.server)
    • Re: Database Maintenance Plan Problems
      ... >may want to create separate maintenance plans for the system databases such ... Expired Transaction Log Backups May Not Be Deleted by Maintenance Plan ... >A maintenance plan job to backup transaction logs may fail. ...
      (microsoft.public.sqlserver.server)
    • Re: database log truncated, transaction log backup job failed
      ... I got it fixed by selecting the specific databases in the Maintenance plan. ... step that runs the transaction log dump". ... Unfortunately, I recall now, that maintenance plans do a good job of ... it seems like the only time you need to backup the transaction logs is ...
      (microsoft.public.sqlserver.tools)
    • Re: Backup SBS 2003
      ... >> backup your system successfully. ... We shouldn't backup the Exchange log files since we are backing ... With the databases, you can decide to move the Exchange ...
      (microsoft.public.windows.server.sbs)
    • Re: Automating SQL Service start and shut down
      ... The best option would be using the Transact-SQL BACKUP command. ... make sure that you know how to restore/recover your data and your databases. ... Grab a tape, restore the files to a different server, and try to get the files restored. ... Moving SQL Server databases to a new location with Detach/Attach ...
      (microsoft.public.sqlserver.setup)