How to grab a copy of my sql 2012 database

Gospodin Rasputin
Gospodin Rasputin used Ask the Experts™
on
I am no database administrator but our support company has requested we send them a copy of the sql database to our support company to help them investigate a fault on the system.

Can someone point me to a step by step on how to take a copy of an sql databse?
Thank you
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
No worry it is simple.

1. Connect SQL server using SSMS (SQL server management studio)
2. Click on New Query.
3 execute this command but please replace <databasename> with your database Name ,
backup file name and location.

 BACKUP DATABASE <DatabaseName> TO  
DISK = N'D:\Backup\DatabaseName_Date.bak'
WITH NOFORMAT, NOINIT, SKIP, NOREWIND, NOUNLOAD, COMPRESSION,  STATS = 10
Vitor MontalvãoIT Engineer
Distinguished Expert 2017

Commented:
Or if you already have a backup maintenance plan just send them the last full backup file. They'll be able to restore it in their environment.
Gospodin RasputinIT  Manager

Author

Commented:
Thanks that worked like magic. I also discovered their application has a DBMgmttool which I could use the following command (similar to yours above) from within the application installation directory so it backs up and zips the database:
DBMgmttool /BACKUP
    /AUTO
    /SERVER=<SERVER NAME>
    /DATABASE=<Database Name>
    /USER=<Application's user name>
    /PASSWORD=<Application's Users Password>

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial