Cloud & SQLSailor

Cloud, Databases & Beyond!

Month: August 2009

  • Start SQL Server Agent Automatically when OS Restarts

    a) Open SQL Server Configuration Manager.b) In SQL Server Configuration Manager, expand Services, and then click SQL Server.c) In the details pane, right-click the name of the instance you want…

  • SQL Management Object Method

    Why to use SQL Management Object Method while using Copy Database option ? Answer : Source database can remain online when the copy activity is being done.

  • Restoring a database with 3 different modes :

    Standby mode will leave the DB in restoring mode,writes are not allowed but user can connect and give select statements. restore database adventureworksLTfrom disk=’c:\backup\adventureworksLTfull.bak’with replace,standby =’c:\backup\adventureworksLT ful.stn’ With recovery mode…

  • Error while restoring a Database : ‘Exclusive access could not be obtained because the database is in use’

    Solution :When we restore the database system should have Exclusive lock. The error means that some process is using this database,we should kill those process which are using database, Otherwise…

  • Microsoft SQL Server Certification Path

    Anyone who dreams about MS SQL 2008 certification can learn more about that here : http://download.microsoft.com/download/6/3/7/6370c653-e270-4e23-9685-15043f63dcce/SQLServer2008_CertPath_Complete.pdf.

  • Anup Warrier’s Space

     Hi Friends, This is meant for sharing my thoughts/findings among the people around me. Trust me, you can find real good tech stuff over here. Happy Blogging 🙂 Thank You,…

Explore