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 |
|
rerun27
Starting Member
3 Posts |
 Posted - 2007-01-15 : 16:02:19
|
| please help me, i need to know if i need to purchase a sql agent for veritas backup exec. i am using the sql msde version only, not the full scale version. any help would be great. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-01-15 : 16:04:55
|
| You don't need to use any third party software to backup databases in MSDE or SQL Express. All of the SQL Server versions give you the BACKUP command. You can schedule the command to run via the Windows Scheduler. You would just use osql.exe or sqlcmd.exe to run the commands.Tara Kizer |
 |
|
|
rerun27
Starting Member
3 Posts |
Posted - 2007-01-15 : 16:11:57
|
| do i need to backup to a folder and then back that folder up? what about the transactional data?thank you very much for answering, not even the company who makes it could give me a clear answer. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-01-15 : 16:18:28
|
| You typically backup the databases to a file on the local disks. You don't backup the actual database files. Check out BACKUP DATABASE command in SQL Server Books Online for details.Tara Kizer |
|
|
|
rerun27
Starting Member
3 Posts |
Posted - 2007-01-15 : 16:31:27
|
| thank you. you were a big help |
|
|
|
|
|
|
backup agent for msde sql version 2005