Skip to Content
0
Former Member
Mar 07, 2014 at 03:40 PM

Change device_fragments usage

252 Views

Hi all,

By mistake it was extended a log device QAS_log_001 without 'log on' command, after that, the message "Caution: You have set up this database to include space on disk 6 for both data and the transaction log. This can make recovery impossible if that disk fails" appeared.
Now the command 'sp_helpdb QAS' show this:

device_fragments size usage created free kbytes
------------------------------ ------------- -------------------- ------------------------- ----------------
QAS_data_001 90112.0 MB data only Nov 13 2013 4:07PM 112
QAS_log_001 10240.0 MB log only Nov 13 2013 4:07PM not applicable
QAS_data_001 10000.0 MB data only Nov 19 2013 9:54AM 0
QAS_data_001 10000.0 MB data only Nov 19 2013 10:06AM 0
QAS_data_001 10000.0 MB data only Jan 28 2014 2:08PM 0
QAS_data_001 30720.0 MB data only Mar 1 2014 10:20AM 18008880
QAS_log_001 10240.0 MB data only Mar 6 2014 1:57AM 10444800
QAS_log_001 10240.0 MB log only Mar 6 2014 2:40AM not applicable

My question is: device QAS_log_001 with usage 'data only' will save ERP data? if not, is it possible to change device usage 'data only' to 'log only' without affecting database consistency?


Thanks for your help!

Ladislao