HOME

▼
Showing posts with label MSSQL Server. Show all posts
Showing posts with label MSSQL Server. Show all posts
Wednesday, 25 March 2020

MS SQL Fill backup and validation check

›
Create Backup database --Create a test database-- Use master go Create database BackupDatabase go  C...
Tuesday, 24 March 2020

MSSQL - Deattach and attach manually by commands

›
sp_helpdb smrtest --Set the database to a single user mode from multiuser mode USE [master] GO ALTER DATABASE [...

MSSQL - Detach and Attach database using GUI

›
1 2 3 4 5 6 ############ ATTACH ####################### 1 2 3 4

MSSQL - Change tempdb mdf and ldf file location

›
sp_helpdb tempdb USE master; GO ALTER DATABASE tempdb MODIFY FILE (NAME = tempdev, FILENAME = 'C:\Program Files\Microsoft SQL...
Wednesday, 11 March 2020

MSSQL SERVER database creation script with specified size and growth

›
USE master GO CREATE DATABASE [Prod]  CONTAINMENT = NONE  ON  PRIMARY ( NAME = N'Prod', FILENAME = N'C:\Program Files\Mi...
Friday, 6 March 2020

MS SQL Server create database command by setting file growth size

›
--Create database command by setting file growth size   CREATE DATABASE [fixed_size]  CONTAINMENT = NONE  ON  PRIMARY  ( NAME...

MS SQL Server Create database command with auto growth

›
Use master go CREATE DATABASE [auto_growth]  CONTAINMENT = NONE  ON  PRIMARY ( NAME = N'auto_growth', FILENAME = N'C:\...

Restore Adventure works DB backup on MSSQL Server 2017 DB using GUI Method

›
step 1 Step 2 : STEP 3: STEP 4: STEP 5 : STEP 6:

Query to check recovery model in MSSQL Server Database

›
Query to check recovery model in database excluding  'master','model','tempdb','msdb' select [name], DAT...
Thursday, 19 December 2019

MS SQL Server case study

›
MS SQL Fill backup and validation check MSSQL - Deattach and attach manually by commands MSSQL - Detach and Attach database using GUI ...

MSSQL -Database Installtion steps developer addition

›
STEP 1: STEP 2: STEP 2a : STEP 3   STEP 4 STEP 5 STEP 6 STEP 7 STEP 8 S...