is .bak the fileformat for SQL 7.0 backup formats...I apologize if i
sound too naive.
yes if you mean the extension for full backups
|||The extension of a file name (like .bak) doesn't say anything about the contents of a file. I can
have an excel file named "a.doc", for instance. Now, some applications might enforce a special
extension. SQL Server doesn't. There is a convention, however, to name database backup using "bak"
as extension.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Erland" <Erland.Erikson@.gmail.com> wrote in message
news:1132614115.754785.181850@.o13g2000cwo.googlegr oups.com...
> is .bak the fileformat for SQL 7.0 backup formats...I apologize if i
> sound too naive.
>
Showing posts with label bak. Show all posts
Showing posts with label bak. Show all posts
Thursday, March 8, 2012
7.0 backup format
is .bak the fileformat for SQL 7.0 backup formats...I apologize if i
sound too naive.yes if you mean the extension for full backups|||The extension of a file name (like .bak) doesn't say anything about the contents of a file. I can
have an excel file named "a.doc", for instance. Now, some applications might enforce a special
extension. SQL Server doesn't. There is a convention, however, to name database backup using "bak"
as extension.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Erland" <Erland.Erikson@.gmail.com> wrote in message
news:1132614115.754785.181850@.o13g2000cwo.googlegroups.com...
> is .bak the fileformat for SQL 7.0 backup formats...I apologize if i
> sound too naive.
>
sound too naive.yes if you mean the extension for full backups|||The extension of a file name (like .bak) doesn't say anything about the contents of a file. I can
have an excel file named "a.doc", for instance. Now, some applications might enforce a special
extension. SQL Server doesn't. There is a convention, however, to name database backup using "bak"
as extension.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Erland" <Erland.Erikson@.gmail.com> wrote in message
news:1132614115.754785.181850@.o13g2000cwo.googlegroups.com...
> is .bak the fileformat for SQL 7.0 backup formats...I apologize if i
> sound too naive.
>
7.0 backup format
is .bak the fileformat for SQL 7.0 backup formats...I apologize if i
sound too naive.yes if you mean the extension for full backups|||The extension of a file name (like .bak) doesn't say anything about the cont
ents of a file. I can
have an excel file named "a.doc", for instance. Now, some applications might
enforce a special
extension. SQL Server doesn't. There is a convention, however, to name datab
ase backup using "bak"
as extension.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Erland" <Erland.Erikson@.gmail.com> wrote in message
news:1132614115.754785.181850@.o13g2000cwo.googlegroups.com...
> is .bak the fileformat for SQL 7.0 backup formats...I apologize if i
> sound too naive.
>
sound too naive.yes if you mean the extension for full backups|||The extension of a file name (like .bak) doesn't say anything about the cont
ents of a file. I can
have an excel file named "a.doc", for instance. Now, some applications might
enforce a special
extension. SQL Server doesn't. There is a convention, however, to name datab
ase backup using "bak"
as extension.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Erland" <Erland.Erikson@.gmail.com> wrote in message
news:1132614115.754785.181850@.o13g2000cwo.googlegroups.com...
> is .bak the fileformat for SQL 7.0 backup formats...I apologize if i
> sound too naive.
>
7.0 and 2000 .BAK incompatibility?
i just got a disk w/ a .bak file on it. when i tried to restore it on
my 2000 sql server instance it said the format was invalid. so, would i
get this error if the .bak version was created using version 7.0?
thanks,
arthur
Arthur,
7 --> 2000 shouldn't be a problem. Try using the HEADERONLY and
FILELISTONLY arguments of the RESTORE statement for the backup.
HTH
Jerry
"arthur" <alangham@.gmail.com> wrote in message
news:1129679111.225814.302070@.g14g2000cwa.googlegr oups.com...
>i just got a disk w/ a .bak file on it. when i tried to restore it on
> my 2000 sql server instance it said the format was invalid. so, would i
> get this error if the .bak version was created using version 7.0?
> thanks,
> arthur
>
|||the specific error i'm getting is RESTORE HEADERONLY is terminating
abnormally. i have no idea what the filelists are in the file. i'm
going to get w/ the peeps that made this file and see what's up. thanks.
|||Hi,
Then try using RESTORE FILELISTONLY OR use Enterprise manager -- All
tasks -- Restore
Filelistonly usage:-
Restore filelistonly from DISK='C:\Backup\backupfile.bak'
Thanks
Hari
SQL Server MVP
"arthur" <alangham@.gmail.com> wrote in message
news:1129680445.762037.102890@.g47g2000cwa.googlegr oups.com...
> the specific error i'm getting is RESTORE HEADERONLY is terminating
> abnormally. i have no idea what the filelists are in the file. i'm
> going to get w/ the peeps that made this file and see what's up. thanks.
>
|||Are you certain this is indeed a SQL Server backup file? It could just have been created with a beta
of SQL Server 7.0, but I think that SQL Server 2000 would give a more descriptive error message.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"arthur" <alangham@.gmail.com> wrote in message
news:1129680445.762037.102890@.g47g2000cwa.googlegr oups.com...
> the specific error i'm getting is RESTORE HEADERONLY is terminating
> abnormally. i have no idea what the filelists are in the file. i'm
> going to get w/ the peeps that made this file and see what's up. thanks.
>
my 2000 sql server instance it said the format was invalid. so, would i
get this error if the .bak version was created using version 7.0?
thanks,
arthur
Arthur,
7 --> 2000 shouldn't be a problem. Try using the HEADERONLY and
FILELISTONLY arguments of the RESTORE statement for the backup.
HTH
Jerry
"arthur" <alangham@.gmail.com> wrote in message
news:1129679111.225814.302070@.g14g2000cwa.googlegr oups.com...
>i just got a disk w/ a .bak file on it. when i tried to restore it on
> my 2000 sql server instance it said the format was invalid. so, would i
> get this error if the .bak version was created using version 7.0?
> thanks,
> arthur
>
|||the specific error i'm getting is RESTORE HEADERONLY is terminating
abnormally. i have no idea what the filelists are in the file. i'm
going to get w/ the peeps that made this file and see what's up. thanks.
|||Hi,
Then try using RESTORE FILELISTONLY OR use Enterprise manager -- All
tasks -- Restore
Filelistonly usage:-
Restore filelistonly from DISK='C:\Backup\backupfile.bak'
Thanks
Hari
SQL Server MVP
"arthur" <alangham@.gmail.com> wrote in message
news:1129680445.762037.102890@.g47g2000cwa.googlegr oups.com...
> the specific error i'm getting is RESTORE HEADERONLY is terminating
> abnormally. i have no idea what the filelists are in the file. i'm
> going to get w/ the peeps that made this file and see what's up. thanks.
>
|||Are you certain this is indeed a SQL Server backup file? It could just have been created with a beta
of SQL Server 7.0, but I think that SQL Server 2000 would give a more descriptive error message.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"arthur" <alangham@.gmail.com> wrote in message
news:1129680445.762037.102890@.g47g2000cwa.googlegr oups.com...
> the specific error i'm getting is RESTORE HEADERONLY is terminating
> abnormally. i have no idea what the filelists are in the file. i'm
> going to get w/ the peeps that made this file and see what's up. thanks.
>
7.0 and 2000 .BAK incompatibility?
i just got a disk w/ a .bak file on it. when i tried to restore it on
my 2000 sql server instance it said the format was invalid. so, would i
get this error if the .bak version was created using version 7.0?
thanks,
arthurArthur,
7 --> 2000 shouldn't be a problem. Try using the HEADERONLY and
FILELISTONLY arguments of the RESTORE statement for the backup.
HTH
Jerry
"arthur" <alangham@.gmail.com> wrote in message
news:1129679111.225814.302070@.g14g2000cwa.googlegroups.com...
>i just got a disk w/ a .bak file on it. when i tried to restore it on
> my 2000 sql server instance it said the format was invalid. so, would i
> get this error if the .bak version was created using version 7.0?
> thanks,
> arthur
>|||the specific error i'm getting is RESTORE HEADERONLY is terminating
abnormally. i have no idea what the filelists are in the file. i'm
going to get w/ the peeps that made this file and see what's up. thanks.|||Hi,
Then try using RESTORE FILELISTONLY OR use Enterprise manager -- All
tasks -- Restore
Filelistonly usage:-
Restore filelistonly from DISK='C:\Backup\backupfile.bak'
Thanks
Hari
SQL Server MVP
"arthur" <alangham@.gmail.com> wrote in message
news:1129680445.762037.102890@.g47g2000cwa.googlegroups.com...
> the specific error i'm getting is RESTORE HEADERONLY is terminating
> abnormally. i have no idea what the filelists are in the file. i'm
> going to get w/ the peeps that made this file and see what's up. thanks.
>|||Are you certain this is indeed a SQL Server backup file? It could just have
been created with a beta
of SQL Server 7.0, but I think that SQL Server 2000 would give a more descri
ptive error message.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"arthur" <alangham@.gmail.com> wrote in message
news:1129680445.762037.102890@.g47g2000cwa.googlegroups.com...
> the specific error i'm getting is RESTORE HEADERONLY is terminating
> abnormally. i have no idea what the filelists are in the file. i'm
> going to get w/ the peeps that made this file and see what's up. thanks.
>
my 2000 sql server instance it said the format was invalid. so, would i
get this error if the .bak version was created using version 7.0?
thanks,
arthurArthur,
7 --> 2000 shouldn't be a problem. Try using the HEADERONLY and
FILELISTONLY arguments of the RESTORE statement for the backup.
HTH
Jerry
"arthur" <alangham@.gmail.com> wrote in message
news:1129679111.225814.302070@.g14g2000cwa.googlegroups.com...
>i just got a disk w/ a .bak file on it. when i tried to restore it on
> my 2000 sql server instance it said the format was invalid. so, would i
> get this error if the .bak version was created using version 7.0?
> thanks,
> arthur
>|||the specific error i'm getting is RESTORE HEADERONLY is terminating
abnormally. i have no idea what the filelists are in the file. i'm
going to get w/ the peeps that made this file and see what's up. thanks.|||Hi,
Then try using RESTORE FILELISTONLY OR use Enterprise manager -- All
tasks -- Restore
Filelistonly usage:-
Restore filelistonly from DISK='C:\Backup\backupfile.bak'
Thanks
Hari
SQL Server MVP
"arthur" <alangham@.gmail.com> wrote in message
news:1129680445.762037.102890@.g47g2000cwa.googlegroups.com...
> the specific error i'm getting is RESTORE HEADERONLY is terminating
> abnormally. i have no idea what the filelists are in the file. i'm
> going to get w/ the peeps that made this file and see what's up. thanks.
>|||Are you certain this is indeed a SQL Server backup file? It could just have
been created with a beta
of SQL Server 7.0, but I think that SQL Server 2000 would give a more descri
ptive error message.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"arthur" <alangham@.gmail.com> wrote in message
news:1129680445.762037.102890@.g47g2000cwa.googlegroups.com...
> the specific error i'm getting is RESTORE HEADERONLY is terminating
> abnormally. i have no idea what the filelists are in the file. i'm
> going to get w/ the peeps that made this file and see what's up. thanks.
>
7.0 and 2000 .BAK incompatibility?
i just got a disk w/ a .bak file on it. when i tried to restore it on
my 2000 sql server instance it said the format was invalid. so, would i
get this error if the .bak version was created using version 7.0?
thanks,
arthurArthur,
7 --> 2000 shouldn't be a problem. Try using the HEADERONLY and
FILELISTONLY arguments of the RESTORE statement for the backup.
HTH
Jerry
"arthur" <alangham@.gmail.com> wrote in message
news:1129679111.225814.302070@.g14g2000cwa.googlegroups.com...
>i just got a disk w/ a .bak file on it. when i tried to restore it on
> my 2000 sql server instance it said the format was invalid. so, would i
> get this error if the .bak version was created using version 7.0?
> thanks,
> arthur
>|||the specific error i'm getting is RESTORE HEADERONLY is terminating
abnormally. i have no idea what the filelists are in the file. i'm
going to get w/ the peeps that made this file and see what's up. thanks.|||Hi,
Then try using RESTORE FILELISTONLY OR use Enterprise manager -- All
tasks -- Restore
Filelistonly usage:-
Restore filelistonly from DISK='C:\Backup\backupfile.bak'
Thanks
Hari
SQL Server MVP
"arthur" <alangham@.gmail.com> wrote in message
news:1129680445.762037.102890@.g47g2000cwa.googlegroups.com...
> the specific error i'm getting is RESTORE HEADERONLY is terminating
> abnormally. i have no idea what the filelists are in the file. i'm
> going to get w/ the peeps that made this file and see what's up. thanks.
>|||Are you certain this is indeed a SQL Server backup file? It could just have been created with a beta
of SQL Server 7.0, but I think that SQL Server 2000 would give a more descriptive error message.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"arthur" <alangham@.gmail.com> wrote in message
news:1129680445.762037.102890@.g47g2000cwa.googlegroups.com...
> the specific error i'm getting is RESTORE HEADERONLY is terminating
> abnormally. i have no idea what the filelists are in the file. i'm
> going to get w/ the peeps that made this file and see what's up. thanks.
>
my 2000 sql server instance it said the format was invalid. so, would i
get this error if the .bak version was created using version 7.0?
thanks,
arthurArthur,
7 --> 2000 shouldn't be a problem. Try using the HEADERONLY and
FILELISTONLY arguments of the RESTORE statement for the backup.
HTH
Jerry
"arthur" <alangham@.gmail.com> wrote in message
news:1129679111.225814.302070@.g14g2000cwa.googlegroups.com...
>i just got a disk w/ a .bak file on it. when i tried to restore it on
> my 2000 sql server instance it said the format was invalid. so, would i
> get this error if the .bak version was created using version 7.0?
> thanks,
> arthur
>|||the specific error i'm getting is RESTORE HEADERONLY is terminating
abnormally. i have no idea what the filelists are in the file. i'm
going to get w/ the peeps that made this file and see what's up. thanks.|||Hi,
Then try using RESTORE FILELISTONLY OR use Enterprise manager -- All
tasks -- Restore
Filelistonly usage:-
Restore filelistonly from DISK='C:\Backup\backupfile.bak'
Thanks
Hari
SQL Server MVP
"arthur" <alangham@.gmail.com> wrote in message
news:1129680445.762037.102890@.g47g2000cwa.googlegroups.com...
> the specific error i'm getting is RESTORE HEADERONLY is terminating
> abnormally. i have no idea what the filelists are in the file. i'm
> going to get w/ the peeps that made this file and see what's up. thanks.
>|||Are you certain this is indeed a SQL Server backup file? It could just have been created with a beta
of SQL Server 7.0, but I think that SQL Server 2000 would give a more descriptive error message.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"arthur" <alangham@.gmail.com> wrote in message
news:1129680445.762037.102890@.g47g2000cwa.googlegroups.com...
> the specific error i'm getting is RESTORE HEADERONLY is terminating
> abnormally. i have no idea what the filelists are in the file. i'm
> going to get w/ the peeps that made this file and see what's up. thanks.
>
Subscribe to:
Posts (Atom)