473,387 Members | 1,504 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Loading db & Read-Only db

I am running SQL 2000 SP2 on a Win 2000 box. I attempted to restore a
dB a couple of times and the restore failed, but the dB appears in EM
twice, once with Loading and the other with Read-Only. I stopped SQL
and attempted to delete the LDF & MDF files, but there was a sharing
violation.

How can I detach these dBs from the SQL server?? Detach is not an
option, because the 'OK' button is not clickable.

HELP anyone.
Larry...

Jul 23 '05 #1
3 1557

<lr*****@gmail.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...
I am running SQL 2000 SP2 on a Win 2000 box. I attempted to restore a
dB a couple of times and the restore failed, but the dB appears in EM
twice, once with Loading and the other with Read-Only. I stopped SQL
and attempted to delete the LDF & MDF files, but there was a sharing
violation.

How can I detach these dBs from the SQL server?? Detach is not an
option, because the 'OK' button is not clickable.

HELP anyone.
Larry...


I guess since you tried to delete the DB files, you want to drop the
database, not detach it? If so, what happens when you use DROP DATABASE from
Query Analyzer?

Simon
Jul 23 '05 #2
I get the following message.....

Server: Msg 3724, Level 16, State 3, Line 1
Cannot drop the database 'po_system-1-24-2005' because it is being used
for replication.

Jul 23 '05 #3

<lr*****@gmail.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...
I get the following message.....

Server: Msg 3724, Level 16, State 3, Line 1
Cannot drop the database 'po_system-1-24-2005' because it is being used
for replication.


I don't know much about replication, but you could try using
sp_removedbreplication first. If that doesn't help, I suggest you ask in
microsoft.public.sqlserver.replication - you'll probably get a better answer
there.

Simon
Jul 23 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Jerivix Entadi | last post by:
I'm attempting to create an application to work with a fluid database of people. I'm doing this in a command line, text-based manner. I need to know two things: 1) How do I save data, perhaps a...
6
by: Rich Wallace | last post by:
All, I receive an xml doc with an element which contains a &amp; in the data. I am attempting to insert the data into a SQL Server database and I want to convert the &amp; to a "&" character before I...
2
by: Hareth | last post by:
i want to make my app save certain things..so i can reload them after I reopen my app.. ex.( save text1.text = "hi" .. to file.so i can to load it to my app later) how can i do that? i need...
6
by: snazzy | last post by:
I have a problem where using innerHTML to rewrite a DIV or removeChild to kill a DIV that either of them, if excuted before the page is done loading will stop the page in its tracks. ...
3
by: Eric A. Johnson | last post by:
In a new project I'm creating, I have my first form that loads being used as a splash screen, with a timer that activates after 5 seconds. I then want the main form to load. However, it isn't...
14
by: Arne | last post by:
A lot of Firefox users I know, says they have problems with validation where the ampersand sign has to be written as &amp; to be valid. I don't have Firefox my self and don't wont to install it only...
1
by: Bob Rock | last post by:
Hello, I'm new to ASP.NET and I've been looking into the topic of dynamically loading (typically accomplished with a LoadControl followed by a MyControl.Controls.Add()) both user controls and...
1
by: insideview | last post by:
I've got this clock script which uses images, and for some reason when it runs, it keeps polling/loading the digits used at the time I thought the fault was with my server or the script, but have...
12
by: InvalidLastName | last post by:
We have been used XslTransform. .NET 1.1, for transform XML document, Dataset with xsl to HTML. Some of these html contents contain javascript and links. For example: // javascript if (a &gt; b)...
5
by: s0suk3 | last post by:
Hi, I wanted to know how cautious it is to do something like: f = file("filename", "rb") f.read() for a possibly huge file. When calling f.read(), and not doing anything with the return...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.