By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,559 Members | 1,154 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,559 IT Pros & Developers. It's quick & easy.

Check SQL Database offline

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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 discussion thread is closed

Replies have been disabled for this discussion.