status-of-database-after-logsegment-seperation.txtHi All,
I just used sp_logdevice to separate the logsegment from a mixed database to a dedicated log device(execution procedure attached) but I can still see the status of the database as 'mixed' even after taking a restart. How ever the fragment information and the details from sysusages are showing appropriate details. Please let me know if am missing anything anywhere.
1> sp_helpdb 'F30'
2> go
name db_size owner dbid created durability lobcomplvl inrowlen status
-------- -------------------------- ---------- -------- ------------------------ -------------------- -------------------- ----------------
--------------------------------------------------------------
F30 30.0 MB sa 12 Jun 07, 2020 full 0 NULL single user, mixed log and data
(1 row affected)
device_fragments size usage created free_kbytes
-------------------------------- -------------------------- ------------------ -------------------------------------- -------------------------------- F30_Data_01 20.0 MB data only Jun 7 2020 1:34AM 16896 F30_Log_01 10.0 MB log only Jun 7 2020 1:36AM not applicable
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
log only free kbytes = 10200 (return status = 0)
1> select * from sysusages where dbid=12 -- corresponds to F30 database
2> go
dbid segmap lstart size vstart location unreservedpgs crdate vdevno
------ ----------- ---------- ---------- ----------- -------- ------------- ------------------------------- -----------
12 3 0 5120 0 0 4224 Jun 7 2020 1:34AM 24
12 4 5120 2560 0 0 2550 Jun 7 2020 1:36AM 25
(2 rows affected)
Regards,
Dilip Voora