Can we bring a Sybase Database offline?
-
Hi All,
Does anyone know if we can bring a sybase (11.9.2) database offline like we can in SQL?
If yes, can you tell me how?
Thanks heaps in advance.
Regards,
TK
-
Strange question for a SQLServer forum, but the short answer - no, you can't! (Well, not easily!)
You could backup the database and then restore it into itself. This will leave the database in an OFFLINE state (you have to manually run the "ONLINE DATABASE" command after restoring a Sybase database to make it useable). This is a bit of a kludge, but it should work.
-
My Sybase is a little rusty ... especially v11.9.2 ...
sp_configure 'allow updates',1
go
reconfigure with override
go
update master..sysdatabases set status = 512 where name = 'your database name'
go
sp_configure 'allow updates',0go
reconfigure with override
go
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
-
Yes, that should work - I was trying to offer a solution that didn't involve messing around with system catalogs!
-
Unfortunately in that version of SYbase there is not one. Also another thought comes to mind. You will also probably need to have 'ts-support' role as well.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
-
Well, I think my first suggestion should work, shouldn't it? Doesn't involve touching system catalogs.
-
Yes Phil it will work. However if you are going to be working with Sybase, especially older versions (pre 12.5) you really should get used to 'mucking' with the system tables. It's just the nature of the beast.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply