Restore SQL Databases to Different Server

[Geoff_Warner]

Hi - we're trying to restore two databases from a server that crashed on us to a different server running sql. The drive that the new sql server is running on is too small to hold the two databases. Is it possible to redirect the databases to a shared drive somewhere on the network? Is it possible to just restore the mdf/ldf files somewhere? What are my options? I've tried both the sql redirection and file redirection restore options and I get either "a000848c - Unable to attach to one of the drives" errors or "a0008492 - Database Query Failure - see job log for details." Please excuse any vagueness/stupidity on my part - it's been a long day.

Thanks in advance,

Geoff

[Geoff_Warner]

I believe I have a solution - I've changed the default location where sql creates new data files in the properties to a larger drive and initiated the sql redirection restore. The database files have appeared in the new directory during the restore and it's lookin' good!