Is this 'FLAT file' backup comprised of ASCII values? In
SQL 6.5 you can use BCP in for ascii files. See details about
BCP and its associated arguments in SQL Server Books Online.
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sql...
> - Anith
DISK REINIT is useful for database devices, not for backup devices. If
you've lost the backup device, you can either:
1) create a new one with the same physical path
2) don't use a backup device. SQL Server lets you load a backup directly
from a file:
LOAD DATABASE mydb from disk = 'C:\MSSQL\BACKUP\customer.dat'
Please make sure you read the online docs to make sure you fully understand
the difference between databases and devices.
MCSE, SQL Server MCT, MVP
(Please do not send email.
Post all followups to the newsgroups.)