Advertisement

07.19.2008 at 10:22AM PDT, ID: 23579231
[x]
Attachment Details

how to stop (pause?)/start msql server for acronis backup

Asked by mobile1 in MS SQL Server, SQL Server 2005, SQL Server 2008

Tags: mcrosoft, mssql server, how to stop / start for acronis backup

We are a small business and have MSQL Server (I believe Version 8) that has 2 databases on it.
The server is running 24/7. We are doing backups with Acronis Echo Server for Windows. Up until now we just backed up the server as it was (older version of Acronis which should backup open files, however it is not perfect obviously thats why we upgraded).

Now the latest version has the option to send pre and post backup commands, to for example stop or pause an mssql server before a backup is done. My question is what are the commands I have to enter for pre and post backup to stop or pause (don't know which one is needed) the db.

So it seems that I have 3 services running, they are

1-Distributed Transaction Coordinator
2-SQL Server
3-SQL Server Agent

So what are the commands to stop or pause the db and to restart afterwards..... Anything else I need to watch out for?Start Free Trial
[+][-]07.19.2008 at 11:11AM PDT, ID: 22043255

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.19.2008 at 11:16AM PDT, ID: 22043267

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.19.2008 at 11:18AM PDT, ID: 22043271

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.20.2008 at 10:41AM PDT, ID: 22046364

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: MS SQL Server, SQL Server 2005, SQL Server 2008
Tags: mcrosoft, mssql server, how to stop / start for acronis backup
Sign Up Now!
Solution Provided By: mark_wills
Participating Experts: 3
Solution Grade: A
 
 
[+][-]07.20.2008 at 10:52AM PDT, ID: 22046392

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.21.2008 at 09:31AM PDT, ID: 22051993

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.21.2008 at 10:15AM PDT, ID: 22052346

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.21.2008 at 10:59AM PDT, ID: 22052805

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.21.2008 at 06:31PM PDT, ID: 22055930

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.23.2008 at 09:58PM PDT, ID: 22076188

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.23.2008 at 10:07PM PDT, ID: 22076222

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.24.2008 at 10:03AM PDT, ID: 22081259

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.24.2008 at 10:39AM PDT, ID: 22081595

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.24.2008 at 12:45PM PDT, ID: 22082794

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.24.2008 at 06:39PM PDT, ID: 22085315

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.24.2008 at 07:45PM PDT, ID: 22085575

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628