Avatar of Gospodin Rasputin
Gospodin Rasputin
 asked on

How to grab a copy of my sql 2012 database

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
Microsoft SQL Server

Avatar of undefined
Last Comment
Gospodin Rasputin

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Deepak Chauhan

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Vitor Montalvão

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 Rasputin

ASKER
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>
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy