DB Restore

Hi all,
We are in need to perform a restore on our staging db box, and we seem to ha
ve a problem. The backup software we use does not have a DB Connector, and a
pparently the .mdf file is simply copied to tape at night! Without SQL Serve
r or the Backup software pr
eforming any detachment or backup process on the file. So we now have a .mdf
file and desperatly need to restore it to a different DB Server - is this p
ossible, or should we forget it?
TIA
AdamYou cold try sp_attach_db or sp_attach_single_file_db, it might work. It is
only documented to work if you actually detached the database (and for
_single_file_, there are more restrictions, check Books Online). I suggest
you do the backup using SQL Server's backup command and pick up the backup
file(s) to tape in the future :-).
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"Adam Stewart" <anonymous@.discussions.microsoft.com> wrote in message
news:76D720B7-3E5E-4900-B2AA-8C66DCF9FB7B@.microsoft.com...
> Hi all,
> We are in need to perform a restore on our staging db box, and we seem to
have a problem. The backup software we use does not have a DB Connector, and
apparently the .mdf file is simply copied to tape at night! Without SQL
Server or the Backup software preforming any detachment or backup process on
the file. So we now have a .mdf file and desperatly need to restore it to a
different DB Server - is this possible, or should we forget it?
> TIA
> Adam