backup extension is?

when you make a backup of an SQL dbase...
what is the extension?
Is it not whatever.bak ?
JimWell that depends on how you did the backup. Some extra information in that
area would surely help to answer that question.
Andrew J. Kelly SQL MVP
"JVRudnick" <JVRudnick@.discussions.microsoft.com> wrote in message
news:D2CA43DA-2737-435A-8039-645FA44D380E@.microsoft.com...
> when you make a backup of an SQL dbase...
> what is the extension?
> Is it not whatever.bak ?
> Jim|||Hi,
There is no limitation on Extension. Backup file extension can be any thing.
Thanks
Hari
SQL Server MVP
"JVRudnick" <JVRudnick@.discussions.microsoft.com> wrote in message
news:D2CA43DA-2737-435A-8039-645FA44D380E@.microsoft.com...
> when you make a backup of an SQL dbase...
> what is the extension?
> Is it not whatever.bak ?
> Jim|||Hmm...
I rec'd an SQL backup file (supposedly) that has NO extension on it at all.
I tried to use it to do a restore, and EM tells me 'sorry, that is not a
backup file..."
'
"Hari Prasad" wrote:

> Hi,
> There is no limitation on Extension. Backup file extension can be any thin
g.
> Thanks
> Hari
> SQL Server MVP
> "JVRudnick" <JVRudnick@.discussions.microsoft.com> wrote in message
> news:D2CA43DA-2737-435A-8039-645FA44D380E@.microsoft.com...
>
>|||Whether or not it has an extension depends on the person who created the bac
kup. SQL Server doesn't
care at all about extensions for backup or database files. They are for our
convenience. Perhaps it
isn't a SQL Server backup file? Did you try RESTORE HEADERONLY?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"JVRudnick" <JVRudnick@.discussions.microsoft.com> wrote in message
news:90C28FB5-0EC6-42B1-BD69-C1FF47515567@.microsoft.com...[vbcol=seagreen]
> Hmm...
> I rec'd an SQL backup file (supposedly) that has NO extension on it at all
.
> I tried to use it to do a restore, and EM tells me 'sorry, that is not a
> backup file..."
> '
> "Hari Prasad" wrote:
>|||Perhaps it's even a detached data file...<shrug> You might want to also
try sp_attach_db
<http://msdn.microsoft.com/library/d...>
-az_52oy.asp>
at a guess.
*mike hodgson*
blog: http:sqlnerd.blogspot.com
Tibor Karaszi wrote:

> Whether or not it has an extension depends on the person who created
> the backup. SQL Server doesn't care at all about extensions for backup
> or database files. They are for our convenience. Perhaps it isn't a
> SQL Server backup file? Did you try RESTORE HEADERONLY?
>|||Good thinking Mike.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Mike Hodgson" <mike.hodgson@.mallesons.nospam.com> wrote in message
news:uFcbTJ4qFHA.2604@.TK2MSFTNGP14.phx.gbl...
> Perhaps it's even a detached data file...<shrug> You might want to also
> try sp_attach_db
> <http://msdn.microsoft.com/library/d...
ae-az_52oy.asp>
> at a guess.
> --
> *mike hodgson*
> blog: http:sqlnerd.blogspot.com
>
> Tibor Karaszi wrote:
>
>|||See if they have used a third party backup utility like the sql liteSpeed
Vikram Vamshi
Database Engineer
Eclipsys Corporation
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:uCgBwRqqFHA.240@.tk2msftngp13.phx.gbl...
> Well that depends on how you did the backup. Some extra information in
> that area would surely help to answer that question.
> --
> Andrew J. Kelly SQL MVP
>
> "JVRudnick" <JVRudnick@.discussions.microsoft.com> wrote in message
> news:D2CA43DA-2737-435A-8039-645FA44D380E@.microsoft.com...
>