iTorn
  • Home
  • Gists
  • Mongo Note
Subscribe
Tagged

MS SQL Server

A collection of 1 post

Copy a database With Script (SQL Server 2008)
MS SQL Server

Copy a database With Script (SQL Server 2008)

Run this on production: USE MASTER; BACKUP DATABASE [MyDatabase] TO DISK = 'C:tempMyDatabase1.bak' -- some writeable folder. WITH COPY_ONLY This one command makes a complete backup copy of the database onto a single file, without interfering with production availability or backup schedule, etc. To restore, just run this

  • Onyx
Onyx 12 เม.ย. 2015 • 1 min read
iTorn © 2022
Powered by Ghost