Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL File 1

Status
Not open for further replies.
Apr 25, 2002
156
0
0
GB
Hi

I have a File that i am wanting to import into SQL Using the Import Data wizard

My Question is the following .....

When i open the file in a Text Editor the first word i see is TAPE

Further into the file i see the following

P G _ O U T P U T b a c k u p s

My question is the following...

I need to know what format this file could be in or if in fact it is a backup from a database ....

Anybody got any clues

regards

rdrunner
 
Sounds like a SQL Backup file.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)
[noevil]
 
Hi,

I was able to restore the database correctly using the help from denny

One further question please.

Is SQL SERVER 2000 also referenced as ver 8.0 ?

That is the version i am using ...

regards

Rdrunner
 
Yep.

--John [rainbow]
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)
 
SQL 7 = SQL 7
SQL 2000 = SQL 8
SQL 2005 = SQL 9

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)
[noevil]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top