Entire 2005 Database deleted

The Database Name is showing up but there are 0 items contained in it. ldf
and mdf files deleted. Not deleted by Users. Event log shows a problem
reading a backup tape.Hi
Refresh SSMS anf the database will probably gone. Do you have a backup of
the database?
"CF" <CF@.discussions.microsoft.com> wrote in message
news:DDE9AD7E-FA19-403E-BE39-21AAD41726E7@.microsoft.com...
> The Database Name is showing up but there are 0 items contained in it.
> ldf
> and mdf files deleted. Not deleted by Users. Event log shows a problem
> reading a backup tape.

Entire 2005 Database deleted

The Database Name is showing up but there are 0 items contained in it. ldf
and mdf files deleted. Not deleted by Users. Event log shows a problem
reading a backup tape.
Hi
Refresh SSMS anf the database will probably gone. Do you have a backup of
the database?
"CF" <CF@.discussions.microsoft.com> wrote in message
news:DDE9AD7E-FA19-403E-BE39-21AAD41726E7@.microsoft.com...
> The Database Name is showing up but there are 0 items contained in it.
> ldf
> and mdf files deleted. Not deleted by Users. Event log shows a problem
> reading a backup tape.

Entire 2005 Database deleted

The Database Name is showing up but there are 0 items contained in it. ldf
and mdf files deleted. Not deleted by Users. Event log shows a problem
reading a backup tape.Hi
Refresh SSMS anf the database will probably gone. Do you have a backup of
the database?
"CF" <CF@.discussions.microsoft.com> wrote in message
news:DDE9AD7E-FA19-403E-BE39-21AAD41726E7@.microsoft.com...
> The Database Name is showing up but there are 0 items contained in it.
> ldf
> and mdf files deleted. Not deleted by Users. Event log shows a problem
> reading a backup tape.

Enterprise manager

hi,i have a SQL server2000,there are some databases on the
server,what I try to achieve is to limit access of each
user. When they log into the server through "Enterprise
manager", they can only view their own database but not
all of them on the server.
thanksYou cannot limit the databases that a user sees through EM. If you want to
do this then you will have to roll your own using something like SQLDMO.
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"pfx" <panfx@.bizcn.com> wrote in message
news:007501c33f80$561e5ca0$a001280a@.phx.gbl...
> hi,i have a SQL server2000,there are some databases on the
> server,what I try to achieve is to limit access of each
> user. When they log into the server through "Enterprise
> manager", they can only view their own database but not
> all of them on the server.
> thanks

Enterprise log in issue

I am using SQL 2000 developer edition and all has been
working fine, until today. In Entrprise manager I can
not log into my local database however I can log into a
remote one. Additionally my local development
applications can access data and function fine they all
use SQL server authentaction.
In enterprise manager whenI try to log in I get the
following message-
Log In Filed for user "name"
please verify your SQL Server is running and check ....
I am sure you all get the idea.
I have tried everything and changed nothing, particularly
any passwords.
Any ideas?
Don
Hi,
Can you try re-registering the Enterprise manager using SQl Authentication
and try connecting. You could
also try connecting to sql server using Query Analyzer.
Since you are able to connect to the application which is accessing the same
sql server , I hope
there will not be any major issue. Still verify the sql server error logs in
\sql server prgram directory\log
Thanks
Hari
MCDBA
"Don Stull" <dstull1@.msn.com> wrote in message
news:OjUiIXMeEHA.2908@.TK2MSFTNGP10.phx.gbl...
> I am using SQL 2000 developer edition and all has been
> working fine, until today. In Entrprise manager I can
> not log into my local database however I can log into a
> remote one. Additionally my local development
> applications can access data and function fine they all
> use SQL server authentaction.
> In enterprise manager whenI try to log in I get the
> following message-
> Log In Filed for user "name"
> please verify your SQL Server is running and check ....
> I am sure you all get the idea.
> I have tried everything and changed nothing, particularly
> any passwords.
> Any ideas?
> Don
>

Enterprise log in issue

I am using SQL 2000 developer edition and all has been
working fine, until today. In Entrprise manager I can
not log into my local database however I can log into a
remote one. Additionally my local development
applications can access data and function fine they all
use SQL server authentaction.
In enterprise manager whenI try to log in I get the
following message-
Log In Filed for user "name"
please verify your SQL Server is running and check ....
I am sure you all get the idea.
I have tried everything and changed nothing, particularly
any passwords.
Any ideas?
DonHi,
Can you try re-registering the Enterprise manager using SQl Authentication
and try connecting. You could
also try connecting to sql server using Query Analyzer.
Since you are able to connect to the application which is accessing the same
sql server , I hope
there will not be any major issue. Still verify the sql server error logs in
\sql server prgram directory\log
Thanks
Hari
MCDBA
"Don Stull" <dstull1@.msn.com> wrote in message
news:OjUiIXMeEHA.2908@.TK2MSFTNGP10.phx.gbl...
> I am using SQL 2000 developer edition and all has been
> working fine, until today. In Entrprise manager I can
> not log into my local database however I can log into a
> remote one. Additionally my local development
> applications can access data and function fine they all
> use SQL server authentaction.
> In enterprise manager whenI try to log in I get the
> following message-
> Log In Filed for user "name"
> please verify your SQL Server is running and check ....
> I am sure you all get the idea.
> I have tried everything and changed nothing, particularly
> any passwords.
> Any ideas?
> Don
>

Enterprise log in issue

I am using SQL 2000 developer edition and all has been
working fine, until today. In Entrprise manager I can
not log into my local database however I can log into a
remote one. Additionally my local development
applications can access data and function fine they all
use SQL server authentaction.
In enterprise manager whenI try to log in I get the
following message-
Log In Filed for user "name"
please verify your SQL Server is running and check ....
I am sure you all get the idea.
I have tried everything and changed nothing, particularly
any passwords.
Any ideas?
DonHi,
Can you try re-registering the Enterprise manager using SQl Authentication
and try connecting. You could
also try connecting to sql server using Query Analyzer.
Since you are able to connect to the application which is accessing the same
sql server , I hope
there will not be any major issue. Still verify the sql server error logs in
\sql server prgram directory\log
Thanks
Hari
MCDBA
"Don Stull" <dstull1@.msn.com> wrote in message
news:OjUiIXMeEHA.2908@.TK2MSFTNGP10.phx.gbl...
> I am using SQL 2000 developer edition and all has been
> working fine, until today. In Entrprise manager I can
> not log into my local database however I can log into a
> remote one. Additionally my local development
> applications can access data and function fine they all
> use SQL server authentaction.
> In enterprise manager whenI try to log in I get the
> following message-
> Log In Filed for user "name"
> please verify your SQL Server is running and check ....
> I am sure you all get the idea.
> I have tried everything and changed nothing, particularly
> any passwords.
> Any ideas?
> Don
>