473,320 Members | 2,054 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,320 software developers and data experts.

Check SQL Database offline

Hello,

I am trying to check the integrity of SQL database. The 'problem' with
SQL server is that it's fixing the DB automatically after restore so I
need a way to do it offline, much like using eseutil on Exchange
databases.

Thanks in advance.
Jul 20 '05 #1
1 6388
mo**@filesx.com (Moti) wrote in message news:<48**************************@posting.google. com>...
Hello,

I am trying to check the integrity of SQL database. The 'problem' with
SQL server is that it's fixing the DB automatically after restore so I
need a way to do it offline, much like using eseutil on Exchange
databases.

Thanks in advance.


I'm not sure that I really understand what your issue is - what do you
mean 'fixing' the database? If you're referring to DBCC CHECKDB, it's
an online operation in SQL2000, although it does affect performance,
so you should be able to run it with users still working in the
database. If you need to take a database offline for some reason, you
can use ALTER DATABASE (see Books Online), although most operations
(backups, many DBCC commands etc) can be run with the database
available as normal.

It might help if you could give more details of your problem - what
version of MSSQL, what commands you're running, what problem or error
messages you get etc.

Simon
Jul 20 '05 #2

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

Similar topics

6
by: T.C. Sheng | last post by:
Hi all, I has experienced a backup/restored problem and need some help. After mydb is restored and roll-forwarded, I received this message: SQL1271W Database "mydb" is recovered but one or...
4
by: Knokmans | last post by:
Hi, All of this is still a test envinonment, but has to go on production.... I restore a database a database the follwing way db2 restore db <database> from <directory. taken at <timestamp>...
7
by: ad | last post by:
I write a restore program to restore a database. But it must stop all connecions to the database before resotre. How can I stop all connecions to the database by program?
1
by: MadCrazyNewbie | last post by:
Hey Group, I wounder if somebody could possibly help me a little? Is it possible to store XLS and DOC files into a MSaccess Database, or SQL Database? If so anybody got any links or tips? ...
5
by: Mitul | last post by:
Hi to all, I am working on a site in which I need to check whether user is online or not. If user successfully logged out then I can change status from online to offline but if user do not...
2
by: V_S_H_Satish | last post by:
Dear Friends I am working as oracle and ms sql dba from last 4 years. My company recently migrated to DB2 databases. So i am very much new to db2 database Can any one pls provide script to...
3
by: Alex | last post by:
Hello, I am running an Access 2003 database, quite modest in size, that is used by upwards of 5 users. I need to modify the database such that these users can work simultaneously and, in some...
2
by: ericthered | last post by:
Hi, I am trying to create an offline database in VB.NET 2005, both the online and offline database use SQL Server 2005. The code I am using seems to run OK with out an exception the DATASET has the...
17
by: darien.watkins | last post by:
Kindof a poll, kindof curiosity... What is your favorite python - database combination? I'm looking to make an app that has a local DB and a server side DB. I'm looking at python and sqlite...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.