[dba-SQLServer]Can anyone give me personalized help

Haslett, Andrew andrew.haslett at ilc.gov.au
Tue Sep 23 21:07:16 CDT 2003


Oops, just saw the last line.  Definitely install into a clean directory.
SQL can't just 'pick' up from existing data files like that.

They need to be restored or attached from a backup using the processes
described in BOL.

Cheers,
Andrew

-----Original Message-----
From: John Colby [mailto:jcolby at colbyconsulting.com]
Sent: Wednesday, 24 September 2003 1:14 AM
To: SQLServer
Subject: [dba-SQLServer]Can anyone give me personalized help


Folks,

I replaced my hard disk in my server and now I am not getting a successful
SQL Server install.  It appears that it runs, I can start the server, but as
soon as I go into Enterprise manager and attempt to drill down to the server
under server group, it stops the SQL Server (the icon in the toolbar goes
red), hangs for a long period (60 seconds or so?) with "Establishing
connection to SQL Server and checking security" in the status bar of
Enterprise manager.  The server eventually displays but there are no
databases at all in the database window, not even the system databases, and
if I attempt to look at some other pieces under there one of them causes a
gpf and EM closes.

Something is seriously wrong, and all my billing data is in a backup waiting
to be restored.

I told it to use an existing directory that already had my old database in
it when I did the install.  Could that be the problem?



John W. Colby
www.colbyconsulting.com


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com

IMPORTANT - PLEASE READ ******************** 
This email and any files transmitted with it are confidential and may 
contain information protected by law from disclosure. 
If you have received this message in error, please notify the sender 
immediately and delete this email from your system. 
No warranty is given that this email or files, if attached to this 
email, are free from computer viruses or other defects. They 
are provided on the basis the user assumes all responsibility for 
loss, damage or consequence resulting directly or indirectly from 
their use, whether caused by the negligence of the sender or not.


More information about the dba-SQLServer mailing list