working with suspect/offline database
Hi,
I manage to get and information on web on how to work with suspect/offline database and the statement is below:
sp_configure 'allow updates',1
GO
RECONFIGURE WITH OVERRIDE
GO
UPDATE master.dbo.sysdatabases
SET Status = 24
WHERE [Name] = 'YourDatabaseName'
GO
and I check in BOL for sysdatabase but I dont find any status=24 represent for what, so where is this number from?
I manage to get and information on web on how to work with suspect/offline database and the statement is below:
sp_configure 'allow updates',1
GO
RECONFIGURE WITH OVERRIDE
GO
UPDATE master.dbo.sysdatabases
SET Status = 24
WHERE [Name] = 'YourDatabaseName'
GO
and I check in BOL for sysdatabase but I dont find any status=24 represent for what, so where is this number from?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi ScottPletcher
I never know that we can this 2 numbers...
I never know that we can this 2 numbers...
ASKER
Look at the link here, they must be confidence to update the status =24 but I'm in ruin to know what is the "24" represent for
http://www.mssqltips.com/tip.asp?tip1204