Hi
You don't need to create a new one
Just select attach database option and provide the path of the MDF and
LDF files.
Thanks
Siddharth
-----Original Message-----
From: Deepak Batra
[mailto:mssqldba-ezmlmshield-x72935012.[Email address protected]
Sent: Tuesday, May 31, 2005 11:44 AM
To: LazyDBA Discussion
Subject: RE: PLEASE HELP
Dear All,
I HAVE RESINSTALLED THE SQL SERVER BUT NOW I AM NOT ABLE
TO CREATE THE DATABASE AGAIN WITH THE SAME NAME. IT IS SAYING THAT THE
DATABASE ALREADY EXISTS THOUGH I HAVE REINSTALLED SQL SERVER.
HOW WILL I RESTORE THE DATABASE WITH THE NAME .MDF AND .LDF FILES, ALSO
HOW WILL I BE ABLE TO SEE THE DATABSE PREVIOUSLY CREATED. PLEASE HELP,
AS I HAVE URGENT REQUIREMENT TO RESTORE THEM ALL AS IT WAS A LIVE
APPLICATION.
REGARDS
DEEPAK
-----Original Message-----
From: Siddharth Vidhani
Sent: Tuesday, May 31, 2005 9:58 AM
To: 'Deepak Batra '; LazyDBA Discussion
Subject: RE: please help
Hi
Please check the event log for the error. Secondly you can copy the data
folder kept in MSSQL folder anywhere. And you can also re install the
sql server. Also when you uninstall SQL server the Data folder is not
removed.
So you can always have the MDF and LDF files.
Thanks
Siddharth
-----Original Message-----
From: Deepak Batra
[mailto:mssqldba-ezmlmshield-x97551615.[Email
<mailto:mssqldba-ezmlmshield-x97551615.%5bEmail> address protected]
Sent: Tuesday, May 31, 2005 10:03 AM
To: LazyDBA Discussion
Subject: please help
Dear All,
There is a problem in restarting SQl Server Service, when I
restart the service, it starts the service, but after few seconds,
automatically stops the service i.e. shows red color and again
disappears. I have not even taken backups, so I cannot re install sql
server.
Please help, I am very new to SQL Service Manager.
With Warm Regards,
Deepak Batra
CONFIDENTIALITY NOTICE
This e-mail transmission and any documents, files, or previous e-mail
messages appended or attached to it, may contain information that is
confidential or legally privileged. If you are not the intended
recipient, or a person responsible for delivering it to the intended
recipient, you are hereby notified that any disclosure, copying,
printing, distribution, or use of the information contained or attached
to this transmission is STRICTLY PROHIBITED. If you have received this
transmission in error, please immediately notify the sender by e-mail
message ([Email address protected] <BLOCKED::mailto:[Email address
protected] ) and delete the original transmission, its attachments, and
any copies without reading or saving in any manner. Thank you.
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com <http://www.lazydba.com/> To unsubscribe:
http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
MS Sql Server LazyDBA home page