SimpleSQLDBA | Shadab Mohammad

Microsoft SQL Server Tips and techniques

Home
Scripts
- Check Memory Pressure for the Current Processes in SQL Server
About

Online

Bring database offline online T-SQL

July 29, 2012July 31, 2012 ~ easyoradba ~ Leave a comment

-- Bring Database Offline USE master GO ALTER DATABASE YourDatabaseName SET OFFLINE WITH ROLLBACK IMMEDIATE GO -- Bring database online USE master ALTER DATABASE SET ONLINE GO

Shadab Mohammad, MCITP

Pages

About
Scripts
- Check Memory Pressure for the Current Processes in SQL Server

2005 2005 2008 2012 2008 2012 Attach Backup Change Command Create Database Mirroring Data Mirroring Deatach Delete DUPLICATE Enable Encryption Execute failover Indexed views Insert Job large Listener Log Login Logins manual Microsoft mirror Mirror Database Mirroring Mode MSSQL Null Offline Online Oracle Partner Powershell Random Rebuild Indexes reconfigure Restore Rows Safety scheduler Scripts Select Server Snapshot Database sp_start_job sql sql-authority sql-query sql-scripts sql-server sql-stored-procedure sql-tips-and-tricks sqlcmd SQL Server 2000 SQL Server 2005 SQL Server 2008 SQL Server 2008 2012 Stored Procedure T-LOG T-SQL Table task technology Transaction Transfer Truncate Log TSQL Windows XP_CMDSHELL

Email Subscription

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 354 other followers

Blog at WordPress.com.

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy