SqlServer-QA.net

In continuation to the SQL Server 2005 - adhoc script to perform backup, restore and integrity checks/optimization jobs without Database Maintenance plans?  blog and scripts by Ola Hallengren, I presume they are very useful for the DBAs who are looking to handle these important tasks in hand with the scripts and not to leave to the GUI or API ...

The following pages were recently modified, rather than posting each as a blog post I have included them here: Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Enterprise X64 EditionNotification Contents: New and All Modifications FIX: A gradual increase in memory consumption for the USERSTORE_TOKENPERM cache store occurs in SQL Server ...

If you have been using the database diagrams from SQL Server 2000 onwards and when it is upgraded to SQL 2005 you might get the following error:  TITLE: Microsoft SQL Server Management Studio------------------------------Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, ...

Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 EditionNotification Contents: New and All Modifications FIX: Error message when you run the CHECKPOINT statement after you restore a database that has a read-only user-defined filegroup in SQL Server 2005: ''The operating system ...

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise EditionNotification Contents: New and Major Modifications Error message when you try to restore a database by using SQL Server Management Studio in SQL Server 2005 after you use the Backup tool: ''Restore failed for Server '<ServerName>' ...