<div>
Instead of starting and stopping the SQL Server, make scheduled backups of the databases to disk (.BAK files) and backup these files with Acronis. <br />
<br />
You can schedule the backups from SQL Managment Studio.<br />

</div>


<div>
As the previous poster has alluded to, database backups are an essential part of database maintenance. Skip them at your peril.
</div>


<div>
See <br />
<br />
<a href="http://chkiran.wordpress.com/2008/06/04/schedule-daily-sql-server-2005-datbase-backup-using-sql-agent/" rel="ugc">http://chkiran.wordpress.com/2008/06/04/schedule-daily-sql-server-2005-datbase-backup-using-sql-agent/</a><br />
<br />
for a walkthrough on how to setup backups. 
</div>


<div>
Oh, and there is a Pause as well, but just denies new logins, existing users &nbsp;are still logged on, and you will still receive a &quot;locked&quot; state in your backup.
</div>


<div>
I think we use sql server 2000, and there are a few reasons why the internal backup sucks I find.<br />
<br />
First I can only backup to the same partition - there seems to be no way to backup to another partition - which I find rather dumb but I guess that's MS. So I used to be able to have a script that moves those backup files to another drive.. but for some reason I can't copy or move those backup files.... I currently have someone looking into that.<br />
<br />
Second, I find internal db backup rather useless for another reason, in comparison to an incremental image (another reason why I have to move the backup files). First if something happens it would take a day or more to setup the server again and get everything setup and installed as it was. With an incremental image I am up and running within an hour or so.<br />
<br />
Having the db backup files on another drive and doing an off site image of the entire server through the internet, gives me 2 levels of security....<br />
<br />
The net start / net stop seems to work, however what do the &nbsp;/f /m parameters do? Also anyone have any ideas why the backup files are not accessible, or even better how to do a backup to another drive?
</div>


<div>
I suggest you contract professional help, you are obviously ignorant as to how MS backups work. &nbsp;Alternatively you can learn the hard way.<br />
<br />
As I stated skip database backups at your own peril.
</div>


<div>
mobile1, I just want to point out some drawbacks with your solution. <br />
<br />
*) If you do the internal database backups you can easily do a transaction log backup every hour which will give you the option to restore to any hour instead of the last 24h backup. <br />
<br />
*) &nbsp;You say if something happens.What is the most likely thing to happen? Hardware failure or an unintentional edit in the database? You can still combinde the two methods also. <br />
<br />
*) If you use the internal backup tools you wont have to take the database offline when you do the backups. This offline time will increase as the database grows. <br />
<br />
*) If you use the full recovery model (which you should) the transaction log will continue to grow if you don't do internal backups since SQL Server <br />
<br />
*) &nbsp;We have SQL Server 2000 and do backups to another partition without any problems so it is possible. <br />
<br />
*) &nbsp;If the backup would suck so bad in SQL Server,. do you really think it would have become the major database product that is is? <br />
<br />
Just some reasons to think about <br />
<br />
For more information on SQL Server switches: <br />
<a href="http://msdn.microsoft.com/en-us/library/ms190737.aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/ms190737.aspx</a><br />

</div>


<div>
Like I said before - I think the SQL Backup is a different question, and there are most definitely a lot of benefits in doing it - it is important for more than just the recovery process - we can talk about how to do, how to set up, and why it is important if you would like to pursue further.<br />
<br />
About those switches - it was really included to show you that you do have some options. The only one I really ever use (apart from &quot;emergency&quot; situations) is the &quot;-s&quot; if using named instances of sql server - I really prefer not using named instances, but some people do.<br />
<br />
The link given above does describe the use of the switches... <br />
<br />
Given that you have indicated that it seems to work, then I would not worry about the switches.<br />
<br />
Just include in the backup function, or, create a batch (or cmd) as scheduled tasks in Windows Scheduler to either shutdown or start as needed. <br />

</div>


<div>
Very good comments here... &nbsp;who of you would consider yourself qualified and expert enough to take a look at our database on our server through gotomypc, look at the existing backup jobs/databases, and setup backup jobs that work to another partition (network drive). Of course we'd pay you for your work.<br />
<br />
Normally this type of support is done through the vendor of the software - however I am questioning a bit their expertise.. the backup guy in charge sets every installation up so that there is a database backup done to the same partition his reasoning is that thats the only thing mssql server can do (not possible to do it to another partition), and that if the hardware blows up in the clean room they can find the file on two locations... &nbsp; Since my database knowledge is very limited slapping an incremental acronis image backup over everything was the best solution, but I agree handling it within the database &nbsp;would be cleaner.<br />
<br />
Anyway if interested shoot me an email to walter &nbsp; aat &nbsp;pointx &nbsp;dott com &nbsp;- I misspelled at and dot intentionally to prevent spider, of course replace those with @ and &quot;&nbsp;. &quot;&nbsp;. Oh and tis is for a dental office. Ideally send me your email, a phone number and a bit of background plus what you'd charge per hour of work.
</div>


<div>
One quick question (well two actually on recount)...<br />
<br />
Who would be doing the recovery process in the unfortunate event of having to do so ? If you are relying on the vendor of the software, and they have seemingly &quot;questionable&quot; processes (and they may have reasons that they do not want to share), then, could any such work potentially compromise that vendor relationship ?<br />
<br />
<br />

</div>


<div>
Hi walter, have sent an e-mail to you - have you received it yet ?
</div>


<div>
Just a word of caution from the EE Guidelines:<br />
<br />
&lt;quote&gt;<br />
<a href="https://www.experts-exchange.com/help.jsp#hi27" rel="ugc">https://www.experts-exchange.com/help.jsp#hi27</a><br />
Section 3: Guidelines for Use<br />
3.4 (G):<br />
The only &quot;currency&quot; you may offer for assistance is points. Offering money or employment is prohibited within any technical thread. It's possible that Experts Exchange may, at some point, offer some kind of &quot;classified advertising&quot; or &quot;Jobs&quot; Zone, but currently, it doesn't.<br />
<br />
<a href="https://www.experts-exchange.com/help.jsp#hi15" rel="ugc">https://www.experts-exchange.com/help.jsp#hi15</a><br />
Using email to resolve a problem<br />
The use of email to resolve a question at Experts Exchange is prohibited. The specific issue is that it gives the emailing Expert an unfair advantage over the other participants in the question. Experts Exchange recognizes that sometimes a particular set of coding or a database that's not behaving is too large to post in its entirety. The solution in that situation is to load it to any of the free websites out there, and then post a link to it -- otherwise, you could be receiving requests for the database long after you've forgotten both the problem and the solution.<br />
<br />
The same applies to the use of Remote Access to resolve a problem. Experts Exchange recognizes that sometimes, the only solution is a hands-on tinkering with a configuration, but this is not something that Experts Exchange offers at this time as a resource to solve your problem. <br />
<br />
A related issue is the posting of email addresses in questions (if you want to post your email address in your profile, that is allowed.) The only people at Experts Exchange who have access to your email address are the office staff and the Administrators -- the Moderators and Zone Advisors do NOT have access to it. By posting your email address, you are subject to receiving email from anyone. The Moderators and Zone Advisors will automatically remove email addresses from questions.<br />
&lt;/quote&gt;
</div>


<div>
Apologies @acperkins, and thanks for the heads up / reminders / caution... &nbsp;Should have posted those comments myself... And yes, moderators do read these postings...<br />
<br />
I believe that the answer to this specific thread has already been supplied with the posting 22046364 ie how to stop / pause sql server. In fact, it was pointed out that the question about SQL backups are probably the basis of a different question. The additional queries and questions about backups are indeed related, but, stems from a realisation that qualified DBA assistance would be beneficial. <br />
<br />
Further, my understanding was that the author was really asking if anyone could recommend such services on a paid basis. In fact, I believe acperkins recommended getting professional help. The Author did use an interesting turn of phrase, and was a bit direct - but obviously out of sheer frustration and perplexities of dealing with DBA type issues, especially when there is a Vendor who is meant to be looking after things. I am not sure we can be so critical of the intentions, other than gentle reminders, such as yours, that direct soliciting is not permitted.<br />
<br />
For the record, I did e-mail, and suggested the services of someone not involved with this posting. And that e-mail has nothing to do with a solution as to &quot;how to stop (pause?)/start msql server for acronis backup&quot;.<br />
<br />
Hope that clarifies a bit more, and thanks again for the caution, and posting those guidelines.
</div>


<div>
Very fair, indeed and no offense intended.
</div>


<div>
And none taken - it is good that these things are brought to our attention.
</div>


<div>
<div class="content wysiwyg-content">
We are a small business and have MSQL Server (I believe Version 8) that has 2 databases on it.<br />
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).<br />
<br />
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.<br />
<br />
So it seems that I have 3 services running, they are<br />
<br />
1-Distributed Transaction Coordinator<br />
2-SQL Server<br />
3-SQL Server Agent<br />
<br />
So what are the commands to stop or pause the db and to restart afterwards..... Anything else I need to watch out for?
</div>
</div>


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?

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

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Acronis sets the standard for cyber protection and hybrid cloud storage through its innovative backup, anti-ransomware, disaster recovery, storage, and enterprise file sync and share solutions. Powered by the Acronis AnyData Engine and strengthened by innovative artificial intelligence and blockchain technologies, Acronis solutions deliver easy, reliable, efficient, secure, and private cyber protection.  Founded in Singapore in 2003, Acronis is celebrating its 15-year anniversary. Supported by more than 1,000 employees worldwide, Acronis’ products are used in over 150 countries, delivering complete protection to more than 5 million consumers and 500,000 businesses. Learn more at acronis.com