<div>
Hello, WillingtonIS!<br />
<br />
That should be the default path for the backup.<br />
<br />
However, <a href="http://www.mytechmantra.com/LearnSQLServer/Changing_Default_Backup_Location.html" rel="ugc">here</a> is a guide on how to change that location.<br />
<br />
Additionally, you should be able to do a search for *.bak to find the location of the backup files.<br />
<br />
Cheers!<br />
Sean
</div>


<div>
Firstly, you pay the contractor, so get him/her to document the back up procedure for you, and include file locations.<br />
<br />
Secondly, to be more helpful, you can find the maintenance plan and check. If you know how to run some SQL, this will tell you the backups that have run in the last day<br />
<br />
Where is says GETDATE() - 1. Change the 1 to however many days you want to go back. The last column tells you where it is written to.<br />
<br />
I found this a while ago on the web, not sure where I'm afraid.<br />
<br />

<pre><code class="code-10 nolinks" id="code-20-41373566-1"><span>SELECT CONVERT(CHAR(100), SERVERPROPERTY('Servername')) AS ServerName, </span>
<span>       msdb.dbo.backupset.database_name,  </span>
<span>       CASE msdb..backupset.type  </span>
<span>           WHEN 'D' THEN 'Database'  </span>
<span>           WHEN 'L' THEN 'Log File'  </span>
<span>       END AS backup_type,  </span>
<span>       msdb.dbo.backupmediafamily.physical_device_name</span>
<span>  FROM msdb.dbo.backupmediafamily  </span>
<span>  JOIN msdb.dbo.backupset</span>
<span>    ON msdb.dbo.backupmediafamily.media_set_id = msdb.dbo.backupset.media_set_id</span>
<span> WHERE CONVERT(datetime, msdb.dbo.backupset.backup_start_date, 102) &gt;= GETDATE() - 1</span>
<span> ORDER BY msdb.dbo.backupset.database_name, msdb.dbo.backupset.backup_finish_date</span>
</code></pre>
</div>


<div>
That would be great if I could understand it. &nbsp;I'm not a DBA at all. &nbsp;I understand how to do small things and I can change the path of the backup too. &nbsp;I'm just trying to figure out where the default is stored. &nbsp;And according to that path that I posted, it's no where to be found?
</div>


<div>
the idiot contract is back on the box. &nbsp;I'll check this out and try to run the query.
</div>


<div>
I ran the query and this was my result:<br />
C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSER<wbr />VER\MSSQL\<wbr />Backup\XT_<wbr />backup_201<wbr />5_12_17_02<wbr />0004_62568<wbr />11.trn<br />
<br />
the problem is C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSER<wbr />VER\MSSQL\<wbr />Backup\ doesn't exist? &nbsp;there is no directory in SQL &nbsp;Server\MSSQL10_50....
</div>


<div>
You're assuming that the backups have been running. If they've been running, they'll be in that folder. If the folder doesn't exist SQL won't create one for it, so it is possible the maintenance job either isn't completing successfully, or it isn't being run at all.<br />
<br />
Is it possible that there is another backup program running like BackupExec?<br />
<br />
What is the contractors reason for not telling you? I would ensure the contract is not renewed for the contractor in question.
</div>


<div>
No backup exec isn't running. &nbsp;Actually I'm trying to determine if I need to purchase the sql part or I can get away with just the backup files only. &nbsp;As far as I know it's been run because it's a script. &nbsp;I don't want to change the path because I don't know if that will mess up the script. &nbsp;The contractor is just being a D...K! (sorry for the language! &nbsp;I ran the backup myself manually and that path is no where to be found??? &nbsp;When I open C:\Program Files Microsoft SQL Server the only thing that appears is 90 and 100
</div>


<div>
I'm right clicking on the database and going to Tasks and selecting Back up &nbsp; see attached.<br />
<a href="https://filedb.experts-exchange.com/incoming/2015/12_w51/1056143/SQL.png" target="_blank" class="file-inline" title="SQL on server (75 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>SQL.png</a>
</div>


SQL.png

<div>
If the maintenance plan has run without error, and you're running management studio on the server where the database is located, then the folders that are referenced in the maintenance plan must exist, otherwise the maintenance job will fail and the job history will tell you it failed. Either that or the backups are being done another way.
</div>


<div>
Yes my inexperience shows I was on the wrong box! &nbsp;I found it. Thanks. &nbsp;I'm going to have my place purchase the sql remote agent and be safe.
</div>


<div>
Ran the script and that told me exactly where it was, however, I was on the wrong server. &nbsp;I was on the application server and not the database server. &nbsp;I didn't realize because SQL Server is on the app server as well.
</div>


<div>
Don't feel annoyed. It's caught me out once or twice. Hence why I asked!!<br />
<br />
:)<br />
<br />
Glad you got it sorted though.
</div>


<div>
You might hear a little giggling from this side of the screen but only because we've all done that or something just as silly in the past.<br />
<br />
Just glad you found a resolution.
</div>


<div>
LOL thanks. &nbsp;As I said I'm a baby in the SQL Server field.
</div>


<div>
hehe, so am I and I've been programming SQL for 15 years!!
</div>


<div>
<div class="content wysiwyg-content">
I have an SQL 2008 R2 server. &nbsp;I'm not a DBA and the nasty contractor I'm dealing with isn't very helpful. &nbsp;I'm trying to locate where the default backup files exist. &nbsp;If you look the path is c:\Program files\SQL Server\MSSQL10_50.MSSQLSER<wbr />VER\MSSQL\<wbr />Backup\...<wbr /> &nbsp;There is not place on the server where this exists????
</div>
</div>


I have an SQL 2008 R2 server.  I'm not a DBA and the nasty contractor I'm dealing with isn't very helpful.  I'm trying to locate where the default backup files exist.  If you look the path is c:\Program files\SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\...  There is not place on the server where this exists????

SQL Server 2008 r2 and default backup files

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

Windows Server 2008 and Windows Server 2008 R2, based on the Microsoft Vista codebase, is the last 32-bit server operating system released by Microsoft. It has a number of versions, including including Foundation, Standard, Enterprise, Datacenter, Web, HPC Server, Itanium and Storage; new features included server core installation and Hyper-V.

Windows Server 2008

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.