Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
swish2408@hotmail.com
Starting Member
3 Posts |
 Posted - 2004-08-05 : 04:24:09
|
| Hello all,I am new to SQL Server and now find myself needing to Back it up.We are using SQL Server Enterprise Manager Version 8. The product has been installed using all defaults. I need to know where on the server, the Data Transformation Services Local Packages are kept so that I can back them up.Please forgive me if this is a simple question, as I said I know nothing about Sql Server and now I find myself having to backup just this directory as we do not need to whole server backed up.It seems to appear within the SQL Enterprise Manager as though it is a directory, however as for as searching the sevrer this directory does not exist. From what I have been reading it saved this location as a msdb file somewhere. Please any advice would be greatly appreciated.Thanks in advanceStephen |
|
|
raymondpeacock
Constraint Violating Yak Guru
367 Posts |
Posted - 2004-08-05 : 04:46:42
|
| You are correct - the msdb database is the store for dts packages. Simply backup this database to backup your dts details.Raymond |
 |
|
|
swish2408@hotmail.com
Starting Member
3 Posts |
Posted - 2004-08-05 : 06:11:08
|
| Thanks for confirming that for me Raymond.Just wondering, would I be correct in saying that this msdb file is the one that by default saves within: C:\Program Files\Microsoft SQL Server\MSSQL$DATABASE\DataIf so, am I able to change the default location of this file to a network drive? Or is that not recommended, rather better that I copy this file to the network for backing up?Thanks again in advanceStephen |
|
|
|
raymondpeacock
Constraint Violating Yak Guru
367 Posts |
Posted - 2004-08-05 : 06:14:21
|
| You can't have SQL Server database files on a network drive - they must exist on a drive local to the server. Setup a database maintenance plan that backs up your databases regularly, and have a subsequent batch job that copies them from the server to the network.Raymond |
|
|
|
swish2408@hotmail.com
Starting Member
3 Posts |
Posted - 2004-08-05 : 06:20:16
|
| Thanks heaps for the prompt advice Raymond. Its greatly appreciated.I'll be putting a maintenance plan together first thing tomorrow.Kindest RegardsStephen |
|
|
|
|
|
|
DTS Backup