SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 SQl BACK UP 2008- No.bak extension
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

SQLNEWBIZ
Starting Member

India
26 Posts

Posted - 02/18/2014 :  04:45:48  Show Profile  Reply with Quote
Hi All,

I have created a backup for the sql server 2008 database.and this I have done in the remote server.So when I checked for the backup I have created in the folder,its not having .bak extension only it have is extension name as file. What is the possibility that its showing wrong? and when I sent that to anyone,the person who is restoring the backup,is not being able to do that.

Please help..Thanks In advance.

djj55
Constraint Violating Yak Guru

USA
333 Posts

Posted - 02/18/2014 :  14:15:48  Show Profile  Reply with Quote
How did you create the backup? Wizard, SSMS, command line?

If you used code, could you show it?

djj
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36997 Posts

Posted - 02/18/2014 :  15:13:26  Show Profile  Visit tkizer's Homepage  Reply with Quote
The file extension doesn't matter. If your Windows Explorer isn't hiding the extension, then the backup file was created without it. This is a problem with whatever ran the backup.

We'll need the error the person got for the restore.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

SQLNEWBIZ
Starting Member

India
26 Posts

Posted - 02/18/2014 :  23:53:40  Show Profile  Reply with Quote
quote:
Originally posted by djj55

How did you create the backup? Wizard, SSMS, command line?

If you used code, could you show it?

djj



I created through ,rightclick database- tasks-- backup-full database- selected the folder for backup -created the file name- And ok..the task completed successfully.
Go to Top of Page

SQLNEWBIZ
Starting Member

India
26 Posts

Posted - 02/19/2014 :  00:18:48  Show Profile  Reply with Quote
quote:
Originally posted by tkizer

The file extension doesn't matter. If your Windows Explorer isn't hiding the extension, then the backup file was created without it. This is a problem with whatever ran the backup.

We'll need the error the person got for the restore.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/



The person who opened the backup file ,got it as a dat file.. He didn't say there was some error.The only thing he told is he couldn't do anything with that file.
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36997 Posts

Posted - 02/19/2014 :  00:23:41  Show Profile  Visit tkizer's Homepage  Reply with Quote
He just needs to restore it. If he's not comfortable with the dat extension, then he can simply rename it to bak.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000