running sql server data marked suspect

hi all,
I run application & database on same machine and suddenly my database marked
suspect and data base is unavailable.
I copy mdf file to other location and try to attached data but it show me
error number 3624 any one help my I don't know why the database marked
suspect and how can I resolve this problem if any one has solution of this
problem then please help me as soon as possible
Thanks in advance
Regards
khurramhttp://www.karaszi.com/SQLServer/in..._suspect_db.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Syed khurram alam" <khurram.alam@.eintelligencesoft.com> wrote in message
news:e1X$u1gVFHA.2684@.TK2MSFTNGP09.phx.gbl...
> hi all,
> I run application & database on same machine and suddenly my database mark
ed suspect and data base
> is unavailable.
> I copy mdf file to other location and try to attached data but it show me
error number 3624 any
> one help my I don't know why the database marked suspect and how can I res
olve this problem if any
> one has solution of this problem then please help me as soon as possible
> Thanks in advance
> Regards
> khurram
>

running sql server data marked suspect

hi all,
I run application & database on same machine and suddenly my database marked
suspect and data base is unavailable.
I copy mdf file to other location and try to attached data but it show me
error number 3624 any one help my I don't know why the database marked
suspect and how can I resolve this problem if any one has solution of this
problem then please help me as soon as possible
Thanks in advance
Regards
khurram
http://www.karaszi.com/SQLServer/inf...suspect_db.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Syed khurram alam" <khurram.alam@.eintelligencesoft.com> wrote in message
news:e1X$u1gVFHA.2684@.TK2MSFTNGP09.phx.gbl...
> hi all,
> I run application & database on same machine and suddenly my database marked suspect and data base
> is unavailable.
> I copy mdf file to other location and try to attached data but it show me error number 3624 any
> one help my I don't know why the database marked suspect and how can I resolve this problem if any
> one has solution of this problem then please help me as soon as possible
> Thanks in advance
> Regards
> khurram
>

running sql server data marked suspect

hi all,
I run application & database on same machine and suddenly my database marked
suspect and data base is unavailable.
I copy mdf file to other location and try to attached data but it show me
error number 3624 any one help my I don't know why the database marked
suspect and how can I resolve this problem if any one has solution of this
problem then please help me as soon as possible
Thanks in advance
Regards
khurramhttp://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Syed khurram alam" <khurram.alam@.eintelligencesoft.com> wrote in message
news:e1X$u1gVFHA.2684@.TK2MSFTNGP09.phx.gbl...
> hi all,
> I run application & database on same machine and suddenly my database marked suspect and data base
> is unavailable.
> I copy mdf file to other location and try to attached data but it show me error number 3624 any
> one help my I don't know why the database marked suspect and how can I resolve this problem if any
> one has solution of this problem then please help me as soon as possible
> Thanks in advance
> Regards
> khurram
>

Running SQL Server at Home

Hi All,

I'm trying to run a copy of Enterprise Manager at home. I have a small wireless network and would like to install it on either one machine (stand-alone) or run it on my network.

The machine it is installed on is running Windows 2000 and the remote machine is running Windows XP Home <<< not sure if SQL Server will run on this.

I tried installing it previously as stand-alone on the Win2K machine, but kept getting a "Server not found or access denied" message whenever I tried to register or connect.

Any ideas on how best to set it up at home would be greatly appreciated.

Thanks,
TimCreate an entry for your sqlserver in hosts (or lmhosts) file. This should help with name/ip resolution. Also, it might be better to setup sqlserver in mixed mode (i.e. allow sql authentication).|||I hope you installed the SQL Server and not the client components alone. Probably, you accepted default values. When you register you can use one of the following: a dot (.), or (local) - including parenthesis - or your workstation computer name. All these are valid in a standalone computer.

Please check your registry under HKEY_LOCAL_MACHINE\Microsoft\MSSQLSERVER\SUPERSOCK ETNETLIB\NP and if the value is like \\.\pipe\sql\query then probably you accepted default value for Named Pipe as well as the instance. If you have decided to install this as an instance then you may see like \\.\pipe\<instance_name>\sql\query then probably you installed as a server.
Also under HKEY_LOCAL_MACHINE\Microsoft\MSSQLSERVER\SUPERSOCK ETNETLIB\TCP, you can determine the port number. If it is 1433 then you used default port.

Please make sure that MSSQLServer Service is running. You can check this through the Services.msc. If you do not see MSSQLServer Service then you have installed the client components only and install the server components. Start SQL Query Analyzer and enter any of the following:

Assumption: Your computer name is PRECAMBRIAN

1) .
2) (local)
3) PRECAMBRIAN
4) PRECAMBRIAN,1433 (or whatever port number is)
5) PRECAMBRIAN\InstanceName

Enter your SA account's password and you should be able to connect.