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 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
>
>|||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?
--
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...
> 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 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
>>|||This is a multi-part message in MIME format.
--040308040903000906030205
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Perhaps it's even a detached data file...<shrug> You might want to also
try sp_attach_db
<http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_ae-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?
>
--040308040903000906030205
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>Perhaps it's even a detached data file...<shrug>Â You might
want to also try <a
href="http://links.10026.com/?link=sp_attach_db</a>">http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_ae-az_52oy.asp">sp_attach_db</a>
at a guess.<br>
</tt>
<div class="moz-signature">
<title> </title>
<meta http-equiv="Content-Type" content="text/html; ">
<span lang="en-au"><font face="Tahoma" size="2">
<p> --<br>
<strong>mike hodgson</strong><br>
blog:Â <a href="http://links.10026.com/?link=http:sqlnerd.blogspot.com</a>">http:sqlnerd.blogspot.com">http:sqlnerd.blogspot.com</a>
</p>
</font></span> </div>
<br>
<br>
Tibor Karaszi wrote:
<blockquote cite="midOdlpdzxqFHA.2996@.tk2msftngp13.phx.gbl" type="cite">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?
<br>
<br>
</blockquote>
</body>
</html>
--040308040903000906030205--|||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/default.asp?url=/library/en-us/tsqlref/ts_sp_ae-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?
>|||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...
>> when you make a backup of an SQL dbase...
>> what is the extension?
>> Is it not whatever.bak ?
>> Jim
>sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment