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 |
|
marcusb
Starting Member
2 Posts |
 Posted - 2004-11-18 : 08:23:42
|
| Hi,I took over a server running MSDE and the logfile is just growing. This results in the server running out of disk space. I have no user interface and want to either truncate or dump the logfile. How do I go about doing it.My data file is located under the default folder (C:\Program Files\Microsoft SQL Server\MSSQL\Data) called R1.mdf and my dB is called RAS.My logfile is located under the default folder (C:\Program Files\Microsoft SQL Server\MSSQL\Data) called R1.ldf.I’ve heard about using the command line but never tried it.I also want to automate backups of the database as follows:Full backup every Sunday @ 22:00Differential backup every day @ 21:00Transaction Log backups every 30 minutesIs there any way one can change the default locations for the data, log and backup files when installing MSDE? |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-11-18 : 14:52:45
|
| If you have SQL Client tools (e.g. Enterprise Manager) running somewhere you can point them at this instance of MSDE and set that stuff up. If not you'll need to craft some SQL to do the job I'm afraid ...Kristen |
 |
|
|
marcusb
Starting Member
2 Posts |
Posted - 2004-11-19 : 08:12:58
|
| Unfortunately I don't have any SQL Client tools and need to do it via command line.Is there any way one can change the default locations for the data, log and backup files when installing MSDE? |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-11-19 : 08:25:28
|
| I believe you can change the default locations of Data/Log on Install, but that won't get you any backups ...You can also set the file locations when you CREATE DATABASE - now are you doing that bit?Kristen |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-11-19 : 09:20:36
|
| Seehttp://www.nigelrivett.net/BackupAllDatabases.htmlThen you just need to schedule the sp calls which you can do via sp_add_job, ap_add_jobschedule, Sp_add_job_step==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Automated backups