forumgogo
05-26-2007, 04:34 AM
hello .
dose any one know how to chang the backup format .bak to .sql
i download the backup of .bak format,but i cant upload as .sql ,i can't chang it .
Burhan
05-26-2007, 05:01 AM
Open the file; its probably SQL text, just the extension is .bak.
forumgogo
05-26-2007, 05:16 AM
thanks.but use which program to open it ?
forumgogo
05-26-2007, 05:39 AM
this is the pic of the backup .
bannerdoers
05-26-2007, 03:48 PM
just change the extension to .sql - and use wordpad or notepad to view it, it's probably just a regular text file
Burhan
05-27-2007, 01:45 AM
Open Notepad, then click and drag the file to the notepad window.
forumgogo
06-05-2007, 11:22 PM
first thank you for your advice.
but,i tried and failed.
there is the pic in the Attached Images
foobic
06-05-2007, 11:49 PM
So, it's a binary file then. Try changing the extension to .zip or .sql.gz and see if Winzip will open it in either case.
Jatinder
06-06-2007, 12:20 PM
MSSQL server backups databases in .bak files. If this is MSSQL backup file, then you will have to use SQL Server Management Studio to import this file to a database.
If you don't have accesss to MSSQL server, then you can download the free express version from http://www.microsoft.com/sql/editions/express/default.mspx
webhostingdesign
06-09-2007, 03:52 PM
hello .
dose any one know how to chang the backup format .bak to .sql
i download the backup of .bak format,but i cant upload as .sql ,i can't chang it .
try opening it in notepad or any plain text editor then saving it with the file extension that you want, this only works for ascii files...