Download

Download

Download

Analyze

Download

Optimize

1

How to restore master database in SQL Server 2005/2008 R2

Friday, July 29, 2011  //  Backup/restore

Background: The master database holds all Instance settings, logins and registers which databases are connected to the server. If the master database gets corrupted SQL Server stops working and the service can’t be started. In this scenario the master database first has to be rebuild before a restore is possible. See article: How to rebuild [...]

Read more & Talk about it
0

How to move temp db in SQL Server 2005/2008 R2

Friday, July 29, 2011  //  Diskmanagement

Background: All temporary results from stored procedures of all databases are temporary stored in the tempdb. Because of its central part in the execution of T-SQL statements it can easily become a performance bottlekneck. To mitigate this it is best to move the tempdb to a fast drive instead of its default location in c:\. [...]

Read more & Talk about it

Can’t find something?

Try the Support section to browse the FAQs.

If you still can’t find the answer try visiting our blog

You can also submit a support request via email.

Search

© 2013 Arthur Graus. All rights reserved