Skip to content
February 7, 2023
  • Subscribe
  • Twitter
  • LinkedIN Group (Forum)
  • Facebook Group (Forum)
  • Facebook Page
  • YouTube
  • Telegram Group (Forum)
SQLServerGeeks

SQLServerGeeks

SQL Server Education (by the geeks, for the geeks)

Free Live Training Virtual Symposium DPD banglore
  • Blogs
    • Subscribe To Our Newsletter
    • SQLServerGeeks Bulletin Index
    • The Scripts Garage
    • All Blog Posts
    • One DMV a Day Series
    • Accidental DBA Series
    • One Operator a Day Series
    • One Trace Flag a Day Series
  • Magazine
  • Events
    • Browse Events
    • Suggest Topics
  • Videos
    • SSG Videos Lobby
    • SQL Server Tutorials & Demos
    • Webinar Recordings
    • SQLShighra Recordings
    • Virtual Symposium Recordings
      • SQL Server & Azure SQL – May 2021
      • SQL Server 2019 & Azure SQL – May 2020
    • Geek Talks
  • RESOURCES
    • SQL Server Resources
    • SQL Server Notes
  • Social
    • Subscribe To Our Newsletter
    • Twitter
    • LinkedIN Group (Forum)
    • Facebook Group
    • Facebook Page
    • YouTube Channel
    • Telegram Group (Forum)
  • About Us
    • Subscribe To Our Newsletter
    • SSG Team
    • Join Us
    • Speakers
    • Blog With Us
    • Contact Us
    • Write a Guest Post
    • Testimonials
    • Join DataPlatformGeeks community
  • Log In
  • Join Now
Main Menu

Tag: restore database

SQL Server / SQL Server Accidental DBA Series

SQL Server restore master database

October 12, 2014December 23, 2019 - by SQL Geek - Leave a Comment

Restore master database is a must know task for any DBA. Master database is one of the key SQL Server database and should be a part of backup/maintenance plan. In case …

SQL Server restore master database Read More
SQL Server / SQL Server Accidental DBA Series

SQL Server restore database with move example

October 11, 2014December 23, 2019 - by SQL Geek - Leave a Comment

A common task for a DBA is to restore a database to a new location. The script for the same is given below USE [master] GO RESTORE DATABASE [AdventureWorks] FROM DISK …

SQL Server restore database with move example Read More
SQL Server / SQL Server Accidental DBA Series

Restore SQL Server database from bak file command line

October 10, 2014December 23, 2019 - by SQL Geek - 1 Comment

Here is a script to restore SQL Server database from bak file command line. This is done via SQLCMD through command line. The first thing is to open up the command …

Restore SQL Server database from bak file command line Read More
SQL Server

SQL Server 2012 Restore Page using SSMS

September 27, 2013September 11, 2014 - by Kanchan Bhattacharyya - Leave a Comment

Dear Friends, Every release of SQL Server shipped with full of new features so is SQL Server 2012. Some of them are Availability Groups, Contained Databases, Column Store Indexes, User Defined roles,  …

SQL Server 2012 Restore Page using SSMS Read More
SQL Server

SQL Server Database States – simple talk but not simpler

September 13, 2013September 11, 2014 - by Kanchan Bhattacharyya - Leave a Comment

Dear Friends, Very recently while imparting training to junior DBAs someone from them asked me what are the different states of a database and how they can move into each stage? …

SQL Server Database States – simple talk but not simpler Read More

Subscribe to SQLServerGeeks


Ad

Virtual Symposium

master classes



SSG_linkedin

SSG_fb

About Us

  • Core Team
  • Authors
  • Blog With Us
  • Testimonials
  • Contact Us
  • Join DataPlatformGeeks Community

Virtual Symposium

Copyright © 2022 SQLServerGeeks. Community initiative by Amit Bansal | Anti-Harassment Policy
Powered by WordPress and HitMag.