HELP! Please Server Crash

I have had a piece of hardware fail (motherboard died),
and I don't have a back up of the entire SQL Box. What I
do have is all the files, master, tempdb, etc etc... in
the directory on the hard drive they were on. They are
fine.
I can't get SQL to run on another box tho, and there is a
humongous amount of jobs, and dts' that I need from there.
The data is fine, but is there a way to get this server
to run on another box?
I am in desparate need.
THank you
SvenInstall SQL Server on the new box .If you remember the paths for the install
,set it up in that fashion. Once completed, stop the SQL server service and
if you remember the exact path names/locations of your data files and log
files , you could restore all those files exactly in the same location
before you start the SQL Server instance on the other box. Give that a try..
"Sven Hansen" <shansen@.westjet.com> wrote in message
news:00c001c3c914$177c3210$a001280a@.phx.gbl...
> I have had a piece of hardware fail (motherboard died),
> and I don't have a back up of the entire SQL Box. What I
> do have is all the files, master, tempdb, etc etc... in
> the directory on the hard drive they were on. They are
> fine.
> I can't get SQL to run on another box tho, and there is a
> humongous amount of jobs, and dts' that I need from there.
> The data is fine, but is there a way to get this server
> to run on another box?
> I am in desparate need.
> THank you
> Sven
>|||After you install SQL , then stop the services and copy all of the files
back. You would then have to use sp_attach_db to attach the non-system
databases..
THe copying over of master, model , tempdb and msdb may or may not work...
The very least thing is that you MUST use the same collation that was
originally used...
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Sven Hansen" <shansen@.westjet.com> wrote in message
news:00c001c3c914$177c3210$a001280a@.phx.gbl...
> I have had a piece of hardware fail (motherboard died),
> and I don't have a back up of the entire SQL Box. What I
> do have is all the files, master, tempdb, etc etc... in
> the directory on the hard drive they were on. They are
> fine.
> I can't get SQL to run on another box tho, and there is a
> humongous amount of jobs, and dts' that I need from there.
> The data is fine, but is there a way to get this server
> to run on another box?
> I am in desparate need.
> THank you
> Sven
>sql

HELP! - cant send mail

xp_sendmail has died on our SQL Server, I get error "xp_sendmail:
failed with mail error 0x80004005" if I try using it.

I believe that the reason that this has happened is because the SQL
Server service account is unable to send mail, as follows:

If I log on to Outlook Web Access as the SQL Server service account
(SVC_SqlServer) I am able to receive mail. However, any mail sent from
this account simply dissapears.

It appears in the Sent items folder (in OWA for the SVC_SqlServer
account) but the recipient (me, in this case) never receives it!

Does anyone know why this account is unable to send mail?

Help!

eddiec :-)chalk@.netspace.net.au wrote in message news:<79744f05.0402112113.3a3a7640@.posting.google.com>...
> xp_sendmail has died on our SQL Server, I get error "xp_sendmail:
> failed with mail error 0x80004005" if I try using it.
> I believe that the reason that this has happened is because the SQL
> Server service account is unable to send mail, as follows:
> If I log on to Outlook Web Access as the SQL Server service account
> (SVC_SqlServer) I am able to receive mail. However, any mail sent from
> this account simply dissapears.
> It appears in the Sent items folder (in OWA for the SVC_SqlServer
> account) but the recipient (me, in this case) never receives it!
> Does anyone know why this account is unable to send mail?
> Help!
> eddiec :-)

This KB article might be helpful:

http://support.microsoft.com/defaul...B;EN-US;q293422

It's not entirely clear from your post if xp_sendmail used to work and
now does not work; if SQL Mail has never worked, then you might also
want to look at this article:

http://support.microsoft.com/defaul...6&Product=sql2k

Simon