Backup and Restore in SQLSERVER 2005

Posted on 2011-04-28
Last Modified: 2012-05-11

Can you please tell me how to restore the backfile to another datbase.

I have 3 SQLSERVER 2005 databases(prod,dev,test)

i want to take the  bakeup of prod databse and restore to test and dev.

Can you please help me out.
Question by:Cha1tu
    LVL 3

    Accepted Solution

    LVL 23

    Assisted Solution

    by:Rajkumar Gs
    This link explain well about backup and restored SQL Server DB

    LVL 23

    Expert Comment

    by:Rajkumar Gs
    Oh!. Same :)
    LVL 2

    Author Comment

    backups are failing here can you help me out..-please find the error in the attachement

    LVL 75

    Assisted Solution

    by:Anthony Perkins
    For those of yhou that cannot open links here is the text from the attachment:
    The backup of full-text catalog 'oncd_activity_note' is not permitted because it is not online. Check errorlog file for the reason that full-text catalog becomes offline and bring it online. Or BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data.
    LVL 75

    Expert Comment

    by:Anthony Perkins
    Incidentally the error message is pretty self-explanatory.  But here is a link that goes into more detail:

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Both Easy and Powerful How easy is PHP? (  Very easy.  It has been described as "a programming language even my grandmother can use." How powerful is PHP?  http://en.wikiped…
    Creating and Managing Databases with phpMyAdmin in cPanel.
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now