Trying to backup the database???

[maryam421]

Hi,
I am very new to sqlserver and trying to learn here. I am trying to do a backup of sqlserver 2000 database. I am using the following commands:

backup database abc to abc
go
restore headeronly from testing

My backup device name is abc and the database name is also abc. Following is the message from first command:

Processed 80 pages for database 'abc', file 'abc_Data' on file 4.
Processed 1 pages for database 'abc', file 'abc_Log' on file 4.
BACKUP DATABASE successfully processed 81 pages in 0.177 seconds (3.708 MB/sec).

When I check the output of second command it shows the following database names

ispbilling
northwind
northwind
northwind
ispbilling
test
ispbilling

which does not include the abc!!
Any one who can guide me how to see the backup I did. Or can tell me little more about the backups and recovery. I am using disk as storage device.
Thanks

 

[SQLBill]

How did you set up the backup device 'abc'? I would start there and check to see if there's any errors in that. Perhaps you set the destination location incorrectly.

-SQLBill

 

[mrdenny]

You need to do you restore from the same backup device you backed up to. You are backing up to device abc but doing the restore headeronly from the device testing which is probably pointing to a different location.

Denny

--Anything is possible. All it takes is a little research. (Me)