Restoring SQL Database

I have the actual .mdf and .ldf files for an SQL database,
not sQL backup files. I need to get this database to a
new SQL server. The server that the previous database was
on was destroyed in a fire, so I can't produce a bakup set
to restore. I have read about attaching a database, and
after running the SP which says it completed successfully,
the database does not appear in the new server. Help
please! Thanks!Matt
Example from the BOL. (NOTE it uses sp_attach_single_files strored
procedure)
For details please refer to BOL.
EXEC sp_detach_db @.dbname = 'pubs'
EXEC sp_attach_single_file_db @.dbname = 'pubs',
@.physname = 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs.mdf'
"Matt" <matt_and_ann@.hotmail.com> wrote in message
news:020801c34e5e$13b22440$a401280a@.phx.gbl...
> I have the actual .mdf and .ldf files for an SQL database,
> not sQL backup files. I need to get this database to a
> new SQL server. The server that the previous database was
> on was destroyed in a fire, so I can't produce a bakup set
> to restore. I have read about attaching a database, and
> after running the SP which says it completed successfully,
> the database does not appear in the new server. Help
> please! Thanks!

Restoring from a fixed allocated database?

We have a backup of a database that is from a database with a fixed
allocation size of 300GB. The actual data itself is small, is there any way
to restore this database without needing 300+GB of space?
Thanks!Not really. You either have to shrink the existing db and do another backup
or export the data and import it into a copy of the db schema (that has much
smaller files).
--
Andrew J. Kelly SQL MVP
"Steven H" <heinz_steven@.emc.com> wrote in message
news:e0qhLigzGHA.4204@.TK2MSFTNGP04.phx.gbl...
> We have a backup of a database that is from a database with a fixed
> allocation size of 300GB. The actual data itself is small, is there any
> way to restore this database without needing 300+GB of space?
> Thanks!
>

Restoring from a fixed allocated database?

We have a backup of a database that is from a database with a fixed
allocation size of 300GB. The actual data itself is small, is there any way
to restore this database without needing 300+GB of space?
Thanks!Not really. You either have to shrink the existing db and do another backup
or export the data and import it into a copy of the db schema (that has much
smaller files).
Andrew J. Kelly SQL MVP
"Steven H" <heinz_steven@.emc.com> wrote in message
news:e0qhLigzGHA.4204@.TK2MSFTNGP04.phx.gbl...
> We have a backup of a database that is from a database with a fixed
> allocation size of 300GB. The actual data itself is small, is there any
> way to restore this database without needing 300+GB of space?
> Thanks!
>