Tag Archives: SysAdmin

SQL Server : Take offline database

EXEC sp_dboption N’mydb’, N’offline’, N’true’\r\nOR\r\nALTER DATABASE [mydb] SET OFFLINE WITH\r\nROLLBACK AFTER 30 SECONDS\r\nOR\r\nALTER DATABASE [mydb] SET OFFLINE WITH\r\nROLLBACK IMMEDIATE

\r\n

    \r\n
  • Using the alter database statement (SQL Server 2k and beyond) is the preferred method.
  • \r\n

  • The rollback after statement will force currently executing statements to rollback after N seconds.
  • \r\n

  • The default is to wait for all currently running transactions to complete and for the sessions to be terminated. Use the rollback immediate clause to rollback transactions immediately.
  • \r\n

Install and Configure SyncML for PocketPC

\r\n
\r\n\r\nThis article describes the process of downloading and installing the Funambol SyncML plugin for the PocketPC. This will allow the synchronization of calendars, contacts, tasks and notes between a SmarterMail user account and the PocketPC. NOTE: SmarterMail does not support Corporate Calendar because it is a special app and does not follow AS standards. This note only effects the Motorola Droid, Droid 2 and Droid X. Funambol 8.5 is recommended to use due to protocol changes that were made in later version.\r\n
    \r\n
  1. \r\n
    Download the SyncML plugin for the PocketPC from the funambol website.
  2. \r\n

  3. \r\n
    Select Windows Mobile PocketPC.
  4. \r\n

  5. \r\n
    You will be prompted to fill out a registration form or you choose to select “No thanks-please take me straight to the downloads”.
  6. \r\n

  7. \r\n
    Download the file funambol plugin for pocketpc to the desktop (or a local download folder).
  8. \r\n

  9. \r\n
    Connect the PocketPC to the Active Sync or Sync Center (Vista).
  10. \r\n

  11. \r\n
    Install the funambol.com plugin by double clicking on funambol plugin.
  12. \r\n

  13. \r\n
    Once the installation is finished you will see to a configuration screen on the PocketPC.
  14. \r\n

  15. The server location needs be for formatted as:\r\nhttp://domainname.com/Sync/Default.aspx\r\n
      \r\n
    • If you are using a port number other than port 80, then the Sever location needs to be formatted as http://domainname.com:9998/Sync/Default.aspx.
    • \r\n

    \r\n

      \r\n
    • Username need to be: username@domainname.com.
    • \r\n

    \r\n

      \r\n
    • Enter password.
    • \r\n

    \r\n

      \r\n
    • Click Save.
    • \r\n

    \r\n

  16. \r\n

  17. \r\n
    After Saving select Sync All.
  18. \r\n

  19. \r\n
    A message will appear requesting a full Sync, click Yes to initiate.
  20. \r\n

\r\n

\r\n

Configure SmarterMail Accounts for Synchronization Using SyncML

SmarterMail uses multiple data synchronization technologies to sync mailbox data with email clients and mobile devices. Before users can sync using SyncML, the system administrator must enable synchronization using SyncML for the domain. NOTE: SmarterMail does not support Corporate Calendar because it is a special app and does not follow AS standards. This note only effects the Motorola Droid, Droid 2 and Droid X. Funambol 8.5 is recommended to use due to protocol changes that were made in later version.\r\n\r\nFollow these steps to enable SyncML for all of the users on a domain:\r\n

    \r\n
  1. Log in as the system administrator.
  2. \r\n

  3. Click the Manage icon.
  4. \r\n

  5. Expand Domains in the left tree view and click All Domains.
  6. \r\n

  7. Select desired domain and click Edit in the actions toolbar.
  8. \r\n

  9. Click the Features tab.
  10. \r\n

  11. Select the Enable SyncML checkbox.
  12. \r\n

  13. Click Save.
  14. \r\n

\r\nSyncML is now enabled for all accounts in the domain. Users will have to install the Funambol SyncML plug-in prior to synchronizing their data with Microsoft Outlook, Mozilla Thunderbird, or most smartphones. For more information on installing this plug-in, refer to the following KB articles:\r\n

\r\nFor more information on SyncML, refer to the Synchronization section of the SmarterMail Online Help.

VirtualBox 4.0.0 Beta 1 released for testing

Oracle has released a first beta for version 4.0.0 of the open source VirtualBox desktop virtualisation application for x86 hardware. According to Oracle’s Frank Mehnert, the preview of the next major update to VirtualBox is considered to be a “bleeding-edge release meant for early evaluation and testing purposes”. \r\n\r\nVirtualBox 4.0.0 Beta 1 features new settings and a disk file layout for VM portability, support for the Open Virtualisation Format Archive (OVA) and a redesigned user interface with guest window preview and a new display mode. Support for asynchronous I/O for iSCSI, VMDK, VHD and Parallels images, as well as resizing VDI and VHD images has also been added. Other changes include support for more than 1.5/2 GB guest RAM on 32-bit hosts, the ability to copy files into a guest file system, support for the Intel ICH9 chip-set and a number of bug fixes.\r\n\r\nAs with all development releases, use in production environments and on mission critical systems is not advised. The developers ask users testing the release not to report issues to the VirtualBox Bugtracker, but instead to provide feedback about any problems they encounter via the VirtualBox forum.\r\n\r\nMore details about the development preview, including a full list of changes and new features, can be found in the official release announcement. VirtualBox 4.0.0 Beta 1 is available to download from the project’s site. The latest stable release of VM VirtualBox is version 3.2.12 from the end of November.\r\n\r\nUpdate: Starting with version 4.0 the license for VirtualBox has changed. For the first time, both the base Oracle VM VirtualBox product source code and the binary are licensed under the GPLv2, while the Extension Pack mechanism, which allows third-party sources to add their own add-on functionality, is licensed under the PUEL. The change means that distributors shipping the Open Source Edition (OSE) of VirtualBox no longer need to build from the sources themselves.\r\n\r\nSource: HOpen, Oracle

FreeNAS 8.0 Beta released

The FreeNAS developers have announced the availability of the first beta for version 8.0 of FreeNAS, a FreeBSD based network attached storage (NAS) Unix like server operating system. FreeNAS Logo\r\n\r\n\r\nAccording to iXsystems FreeBSD Development Director Warner Losh, “the new FreeNAS makes it easier to upgrade, back up, or restore, with the system taking care of all the details,” adding that, “FreeNAS makes running a NAS box simple and easy”. FreeNAS includes a full Web configuration graphical user interface (GUI) and supports, for example, the FTP, NFS, CIFS (Samba), AFP, rsync and iSCSI protocols and software RAID (0,1,5).\r\n\r\nBased on FreeBSD 8.1, the development release features version 14 of the ZFS (Zettabyet File System) and includes a redesigned graphical user interface (GUI) built using Python and the Django web framework that’s aimed at making the OS easier to use. The developers say that the new system is much more modular than previous versions and, in addition to using Django, they are also using theDojo Toolkit to implement AJAX features.\r\n\r\nOther changes include improved hardware support, faster I/O and better modularity. Additionally, the installer has been rewritten using pc-sysinstall and the ISO now only includes an installer to install FreeNAS onto a dedicated device, such as a USB flash drive, hard drive or memory card – users can no longer run in a LiveCD mode.\r\n\r\nLosh notes that, after the first beta build was released (r5591), a few “serious problems came to life”. As such, they have re-spun the release to address a variety of issues, including gmirror errors, very long write times for disks and a ZFS problem on reboot.\r\n\r\nAs with all development releases, use in production environments and on mission critical systems is not advised. Users testing the release are encouraged to provide feedback and report any bugs that they encounter.\r\n\r\nFurther information about the development preview can be found in the official release announcement and in the release notes. A detailed change log has yet to be posted. FreeBSD 8.0 Beta build r5606 is available to download fromSourceForge.\r\n\r\nFreeNAS was voted as one of the ten best networking tools in InfoWorld’s 2010Best Open Source Software Awards. The latest stable release is version 0.7.2from the 17th of October.

Backup IIS7 ApplicationHost.config and Settings

\r\n
Internet Information Services 7 (IIS7) doesn’t use metabase-like file from IIS6. Instead the settings and configuration are stored in schema files and applicationHost.config files.\r\n\r\nSince the configuration files are different, the old IIS6 tools will not be able to backup IIS7 settings.\r\n\r\nThis is the new script that you can use to backup your IIS7 web servers.\r\n\r\n1. Using notepad or any text editor create a file backupiis7.cmd\r\n\r\n2. Insert the following code and save the file:\r\n
\r\n
Code:

\r\n

@echo off\r\ncls\r\n\r\npushd "%WinDir%\System32\inetsrv"\r\n\r\necho.| date | find /i "current">datetime1.tmp\r\necho.| time | find /i "current">datetime2.tmp\r\n\r\nfor /f "tokens=1,2,3,4,5,6" %%i in (datetime1.tmp) do (\r\n  echo %%n>datetime1.tmp\r\n)\r\nfor /f "tokens=1,2,3,4,5,6" %%i in (datetime2.tmp) do (\r\n  echo %%m>datetime2.tmp\r\n)\r\nfor /f "delims=/ tokens=1,2,3" %%i in (datetime1.tmp) do (\r\n  set TMPDATETIME=%%k%%i%%j\r\n)\r\nfor /f "delims=:. tokens=1,2,3,4" %%i in (datetime2.tmp) do (\r\n  set TMPDATETIME=D%TMPDATETIME%T%%i%%j%%k%%l\r\n)\r\n\r\nappcmd add backups %TMPDATETIME%\r\n\r\ndel datetime1.tmp\r\ndel datetime2.tmp\r\n\r\nset TMPDATETIME=\r\n\r\npopd\r\necho.

\r\n

\r\n3. The IIS7 configuration will be backed up at the following path:\r\n

\r\n
C:\Windows\System32\inetsrv\backup

\r\n

\r\nNOTE: you can also use Task Scheduler to automate backups.

\r\n

Hello world!

Welcome to Community\r\n\r\nWelcome to SysAdmin community site. You’ll get help, news, discussions and collection of tools for System administration & IT Professionals. The target is to make this community to be one of biggest community of System Administrators and IT Professionals.