• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3538
  • Last Modified:

how do i open .bak file on SQL Server 2012 ?

i copy .bak file 8GB to my local computer i installed SQL server 2012 with studio manager how do i open this .bak file

Thanks
Gvilbis
0
gvilbis
Asked:
gvilbis
4 Solutions
 
x-menIT super heroCommented:
Restore filelistonly from disk = 'MyPath\Myfile.bak'

wil give you the contents of the bakup file.
0
 
Surendra NathTechnology LeadCommented:
you cannot open a .bak file with SSMS, it will be used to restore the database.

In simple terms, you cannot open it, just like that you have to follow a procedure to open it (it will be correct to say to restore it).


The below link have a step by step guide on how to do it.
http://www.katieandemil.com/sql-server-2012-restore-database-backup-file
0
 
engmgsCommented:
.bak is a backup file generated in sql server .

Backup files importing means resotring a database ,you can restore on a database created in sql server 2012 but the backup file should be from SQL 2005,2008,2008r2,2012 database.

You restore database by using following command...

RESTORE DATABASE YourDB FROM DISK = 'D:BackUpYourBaackUpFile.bak' WITH Recovery

you want to learn about how to restore .bak file follow the below link:

http://msdn.microsoft.com/en-us/library/ms186858(v=sql.90).aspx
0
 
Ramesh Babu VavillaCommented:
restore database dbname from disk =' .bak file pth'
if you backup file is generated in SQL Server 2000. you cant restore it , to work out
you have to restore it on SQL Server 2008 and then on SQL Server 2012
0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now