Database question...

I have a database that was on a SQL Server that failed. The data file is
intact
but I need to bring it up. What steps do I need to do in order to attach
this to
another SQL Server with the plan of maving it back to the original server
once we
get the server rebuilt.
Any help would be greatly appreciated.You might be able to use sp_attach_db of you have all the files that constit
utes the database. A
database backup file is better (RESTORE DATABASE). You also need to make sur
e that login exists at
the new server (and other stuff needed in the system databases) and then han
dle login to use mapping
(sp_change_users_login).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Joe" <Joe@.discussions.microsoft.com> wrote in message
news:EA95EEE6-1FD6-41E8-A65E-7F8A647A7D55@.microsoft.com...
>I have a database that was on a SQL Server that failed. The data file is
> intact
> but I need to bring it up. What steps do I need to do in order to attach
> this to
> another SQL Server with the plan of maving it back to the original server
> once we
> get the server rebuilt.
> Any help would be greatly appreciated.|||If your data file is intact, you can try sp_attach_single_file_db too...
"Joe" wrote:

> I have a database that was on a SQL Server that failed. The data file is
> intact
> but I need to bring it up. What steps do I need to do in order to attach
> this to
> another SQL Server with the plan of maving it back to the original server
> once we
> get the server rebuilt.
> Any help would be greatly appreciated.