Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

MSDE 7 and database management

Posted on 2013-05-22
2
Medium Priority
?
353 Views
Last Modified: 2013-05-24
I'm receiving a log error which I believe indicates the database has maxed out, and I suspect I need to either grow the database, or backup the database.

The version shows 2000.28.9.0

I understand with SQL 7 the GUI backup interface only comes with the full version install (which includes SQL enterprise manager).  If I don't have that, is there another management tool that I can install, or can you point me to documentation that will illustrate how to backup using command line (if it is even an option...)

All help is appreciated.
0
Comment
Question by:ITDharam
2 Comments
 
LVL 4

Accepted Solution

by:
rlog earned 2000 total points
ID: 39189921
You can install SQL 2000 Enterprise manager and connect to your SQL 7 database. Otherwise you can connect using the osql tool. There are other tools as well to connect and do basic managemnet tasks. I used Aqua myself previously for task like you are looking for. I have not tried this new verison.
0
 
LVL 8

Author Comment

by:ITDharam
ID: 39190986
Can SQL 2000 Enterprise Manager be downloaded (If so, please send link)?  Or is that only available with the media for SQL 2000?
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question