We wish to use these pages for publishing various documents, announcements, FAQ etc related to beyondrelational.com...

Hi Ana, Thank you for this sentence : .."With offline restore we first need to take log backup with NORECOVERY option".... Danny...

Blog about SQL Server and related technologies....

Hi jacob Good point about only Data backup can prevent the transaction logs from getting truncated (not restore) But from : http://msdn.microsoft.com/en-us/library/ms345414.aspx we can read : Data Backup Operations and Restore Operation...

Hi Jacob, **What are the points you would carefully consider when planning the storage for transaction logs?** Performance, size, RECOVERY MODE, backup log frequency, clustered index, Rebuild index OR reorganize index, auto-grows or not Mo...

Why it is important to maintain Temporary database? For overall performance of SQL Server : Many temporary components are continiously created and deleted on TEMPDB. TEMPDB is used by all databeses on the instance of SQL Server. Determine...

I don't know ;-)...

From : http://explainextended.com/2009/10/14/constraints-and-the-optimizer-in-sql-server-unique/ *"...Since these constraints ( **PRIMARY KEY UNIQUE FOREIGN KEY CHECK DEFAULT** ) imply some restrictions on data, it gives a theoretic...

I just want share one problem faced by me. this morning.... last night I were playing with network options and today I got one error while establishing connection with ssms A network-related or instance-specific error occurred while establishing a...

I just want share one problem faced by me. this morning.... last night I were playing with network options and today I got one error while establishing connection with ssms A network-related or instance-specific error occurred while establishing a...