To change the logical name of the SQL Server databse one can follow the steps below to change the logical name of database data file and log file. You may want to take a backup of the database before applying the change to ensure you have a rollback. Example: Use test select fileid, name, filename … Continue reading How to change logical name of SQL Server database?
Tag: logical
How to check physical and logical data corruption using RMAN?
If you are not using RMAN to backup data and use technologies like NetApp snapshot which doesn't check for physical and logical corruption, one can still use RMAN to check for physical and logical corruption in the datafiles and not back the data up. connect target / run { # set disk to be default … Continue reading How to check physical and logical data corruption using RMAN?
alexlima.com 