Restoring sysdevices with disk reinit  Chapter 14: Automatic Database Expansion

Chapter 13: Restoring the System Databases

Restoring sysusages and sysdatabase with disk refit

If you have added database devices or created or altered databases since the last database dump, use disk refit to rebuild the sysusages and sysdatabases tables.

disk refit can be run only from the master database and only by a System Administrator. Permission cannot be transferred to other users. Its syntax is:

disk refit 

Adaptive Server shuts down after disk refit rebuilds the system tables. Examine the output while disk refit runs and during the shutdown process to determine whether any errors occurred.

WARNING! Providing inaccurate information in the disk reinit command may lead to permanent corruption when you update your data. Check Adaptive Server with dbcc after running disk refit.





Copyright © 2005. Sybase Inc. All rights reserved. Chapter 14: Automatic Database Expansion

View this book as PDF