Check SQL Database offline

[Moti]

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.

[Simon Hayes]

mo**@filesx.com (Moti) wrote in message news:<48******* *************** ****@posting.go ogle.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