Database maintenance involves the administration, optimization, and performance tuning of the database, its infrastructure, and database groups in the enterprise. Ask questions related to the management aspects of various databases.
4
votes
3answers
537 views
Stop SQL Server service(s) before defragmenting drive?
Our production SQL Server 2005 database's data files live on a separate physical drive, which Microsoft Windows 2003's Disk Defragmenter tool reports as 99% fragmented.
We scheduled a task to ...
4
votes
2answers
281 views
SQL Server 2012 database backup successfully report but no backup file
I have created maintenance plan in SQL Server 2012. And every day, the maintenance plan should backup the database. There is no database backup file when I look in the folder where the backups must ...
