Here is a great post on how to determine if Windows Azure SQL Database or SQL Server deployed to a Windows Azure VM.
Continue ReadingTag: SQL Server
Shrink SQL Server Data and Log files
The below syntax will allow you to shrink a SQL Server Database Data File and Transaction Log File — Truncate the log BACKUP LOG biztalkdtadb WITH TRUNCATE_ONLY — Shrink Log File dbcc shrinkdatabase (BizTalkDTADb, 10)
Continue ReadingQuest Tools
LiteSpeed – for SQL Server ———————————- In summary LiteSpeed is a backup utility. This backup tool is being used by Microsoft and some of the leading banks to backup there SQL Server. This backup utility
Continue Reading