none
how to make .bak up file of a database in SQL server 2008 R2 ?

    Question

  • Greetings,

    I want to know what is the procedure to take .bak file of a database of sql server 2008 R2 and also how to restore that file , without running any sql query.

    Wednesday, September 04, 2013 8:32 AM

Answers

  • Greetings,

    I want to know what is the procedure to take .bak file of a database of sql server 2008 R2 and also how to restore that file , without running any sql query.

    To backup a database using SSMS:

    http://www.theboreddba.com/Categories/backupAndRestore/Backup-a-Database-Using-SQL-Server-Management-Studio.aspx

    To restore a database using SSMS:

    http://www.howtogeek.com/50354/restoring-a-sql-database-backup-using-sql-server-management-studio/

    Wednesday, September 04, 2013 9:22 AM
  • Hi,

     when you perform the back up task which normally pops up a window and click the ADD button  which pops up a different window where you can specify the location of the back file for being stored by clicking on the small dotted tab present next to the default path of the FILE NAME. In the new window down the bottom you need to specify the type of file and the name of the file with the .bak extension and proceed to perform the back up.

    Now you can actually go to the location as specified and check the .bak file exists

    Comming to the second part of your question, SQL server does not support backward compatibility as i presume if you are trying to restore a back up of a databse on SQl2008 to a database on SQl2005 which is not possible

    thanks,

    Bhanu

    • Marked as answer by nusrat sharmin Monday, September 09, 2013 4:58 AM
    Monday, September 09, 2013 3:01 AM

All replies

  • Please read

    Backup

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

    http://technet.microsoft.com/en-us/library/ms186865.aspx

    Restore

    http://technet.microsoft.com/en-us/library/ms177429.aspx

    http://technet.microsoft.com/en-us/library/ms186858.aspxvt


    Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker

    • Proposed as answer by Shanky_621 Wednesday, September 04, 2013 9:23 AM
    Wednesday, September 04, 2013 8:35 AM
  • open your sql enterprise manager go to data base right click select the restore
    data base for the bak files and select it from device and 
    target your bak file location then you can restore the data thats all.
    Wednesday, September 04, 2013 8:39 AM
  • Greetings,

    I want to know what is the procedure to take .bak file of a database of sql server 2008 R2 and also how to restore that file , without running any sql query.

    To backup a database using SSMS:

    http://www.theboreddba.com/Categories/backupAndRestore/Backup-a-Database-Using-SQL-Server-Management-Studio.aspx

    To restore a database using SSMS:

    http://www.howtogeek.com/50354/restoring-a-sql-database-backup-using-sql-server-management-studio/

    Wednesday, September 04, 2013 9:22 AM
  • Dear _Kevin Urquhart,

    Thanks for ur co-operation , i have go through this and also tried but, it doesnot store .bak file, reather it's extesion says only file, not .bak file. (as an example: it store a file name XX where it shows named file as extention) not .bak ... so when i m going to restore this file it gives an error message showing uncompatible with previous version. 

    You can consider me as a fresher in SQL server tool management. Please give me a prompt and helpful solution.

    for better understainding i m giving u snap shot.

    


    Nusrat

    Sunday, September 08, 2013 12:00 PM
  • Hi,

     when you perform the back up task which normally pops up a window and click the ADD button  which pops up a different window where you can specify the location of the back file for being stored by clicking on the small dotted tab present next to the default path of the FILE NAME. In the new window down the bottom you need to specify the type of file and the name of the file with the .bak extension and proceed to perform the back up.

    Now you can actually go to the location as specified and check the .bak file exists

    Comming to the second part of your question, SQL server does not support backward compatibility as i presume if you are trying to restore a back up of a databse on SQl2008 to a database on SQl2005 which is not possible

    thanks,

    Bhanu

    • Marked as answer by nusrat sharmin Monday, September 09, 2013 4:58 AM
    Monday, September 09, 2013 3:01 AM
  • Dear Bhanu,

     Thanks for your response.

    Regards, 

    Nusrat.


    Nusrat

    Monday, September 09, 2013 5:00 AM