Overclock.net › Forums › Specialty Builds › Servers › Scheduling backups with SQL Server 2005 Express
New Posts  All Forums:Forum Nav:

Scheduling backups with SQL Server 2005 Express

post #1 of 9
Thread Starter 
Basically I have replaced my dad's friend's IT guy. They are a small business and they run a single database (~2GB in size). I know 2005 Express doesn't have a way to schedule backups out of the box. I have done some google searching and found a few guides, but I am pretty new to SQL Server and don't want to mess something up.

Anyone have some experience scheduling backups with SQL Server 2005 Express? Currently I am manually running backups and its getting old fast.
Main PC
(10 items)
 
File Server
(11 items)
 
 
CPUMotherboardGraphicsRAM
i5 2550k ASUS Maximus V GENE EVGA GeForce GTX 660 Ti+ 3GB w/Backplate 16GB Kingston Hyper-X 
Hard DriveHard DriveCoolingOS
2x Kingston HyperX 3K RAID 0 Seagate USB 3.0 External Drive Thermalright Venomous X Windows 10 Pro x64 
MonitorPower
3x 22" Dell Ultrasharp Corsair CX500 
CPUMotherboardRAMHard Drive
amd a10-7700k ASrock FM2A88M-HD+ Corsair Dominator 2x2GB Toshiba 
Hard DriveHard DriveHard DriveHard Drive
Toshiba Western Digital Green Western Digital Black Western Digital Green 
OSPowerCase
Windows Professional 8.1 OCZ 650W Antec 300 
  hide details  
Reply
Main PC
(10 items)
 
File Server
(11 items)
 
 
CPUMotherboardGraphicsRAM
i5 2550k ASUS Maximus V GENE EVGA GeForce GTX 660 Ti+ 3GB w/Backplate 16GB Kingston Hyper-X 
Hard DriveHard DriveCoolingOS
2x Kingston HyperX 3K RAID 0 Seagate USB 3.0 External Drive Thermalright Venomous X Windows 10 Pro x64 
MonitorPower
3x 22" Dell Ultrasharp Corsair CX500 
CPUMotherboardRAMHard Drive
amd a10-7700k ASrock FM2A88M-HD+ Corsair Dominator 2x2GB Toshiba 
Hard DriveHard DriveHard DriveHard Drive
Toshiba Western Digital Green Western Digital Black Western Digital Green 
OSPowerCase
Windows Professional 8.1 OCZ 650W Antec 300 
  hide details  
Reply
post #2 of 9
I have a cash register system at my work which runs sql server for the database, the register program came with a separate process that runs in windows that controls the backup.

I know its not much direct help, but just letting you know that it is possible and perhaps you should try and find an independent program to back up the database.
My System
(13 items)
 
  
CPUMotherboardGraphicsRAM
I5 760 GA-H55N GTX 470 PNY Optima 8GB 
Hard DriveMonitorPowerCase
Spinpoint F4 LG227WTG sg07 PSU Sugo sg07 
Mouse
CM Sentinel 
  hide details  
Reply
My System
(13 items)
 
  
CPUMotherboardGraphicsRAM
I5 760 GA-H55N GTX 470 PNY Optima 8GB 
Hard DriveMonitorPowerCase
Spinpoint F4 LG227WTG sg07 PSU Sugo sg07 
Mouse
CM Sentinel 
  hide details  
Reply
post #3 of 9
Thread Starter 
I have seen a few scripts and small programs that claim to do just that. I just don't know what's good and what isn't. I may end up installing SQL Server on my virtual machine to test, but I'd prefer to save time.
Main PC
(10 items)
 
File Server
(11 items)
 
 
CPUMotherboardGraphicsRAM
i5 2550k ASUS Maximus V GENE EVGA GeForce GTX 660 Ti+ 3GB w/Backplate 16GB Kingston Hyper-X 
Hard DriveHard DriveCoolingOS
2x Kingston HyperX 3K RAID 0 Seagate USB 3.0 External Drive Thermalright Venomous X Windows 10 Pro x64 
MonitorPower
3x 22" Dell Ultrasharp Corsair CX500 
CPUMotherboardRAMHard Drive
amd a10-7700k ASrock FM2A88M-HD+ Corsair Dominator 2x2GB Toshiba 
Hard DriveHard DriveHard DriveHard Drive
Toshiba Western Digital Green Western Digital Black Western Digital Green 
OSPowerCase
Windows Professional 8.1 OCZ 650W Antec 300 
  hide details  
Reply
Main PC
(10 items)
 
File Server
(11 items)
 
 
CPUMotherboardGraphicsRAM
i5 2550k ASUS Maximus V GENE EVGA GeForce GTX 660 Ti+ 3GB w/Backplate 16GB Kingston Hyper-X 
Hard DriveHard DriveCoolingOS
2x Kingston HyperX 3K RAID 0 Seagate USB 3.0 External Drive Thermalright Venomous X Windows 10 Pro x64 
MonitorPower
3x 22" Dell Ultrasharp Corsair CX500 
CPUMotherboardRAMHard Drive
amd a10-7700k ASrock FM2A88M-HD+ Corsair Dominator 2x2GB Toshiba 
Hard DriveHard DriveHard DriveHard Drive
Toshiba Western Digital Green Western Digital Black Western Digital Green 
OSPowerCase
Windows Professional 8.1 OCZ 650W Antec 300 
  hide details  
Reply
post #4 of 9
I use this one with several clients, works fine.
http://www.mydigitallife.info/2009/0...-2005-express/
post #5 of 9
Thread Starter 
Thanks Dave. I have seen that guide but I am really a SQL noob.

For step one, do I need to change anything for example should @databasename be changed to the actual database name?
Main PC
(10 items)
 
File Server
(11 items)
 
 
CPUMotherboardGraphicsRAM
i5 2550k ASUS Maximus V GENE EVGA GeForce GTX 660 Ti+ 3GB w/Backplate 16GB Kingston Hyper-X 
Hard DriveHard DriveCoolingOS
2x Kingston HyperX 3K RAID 0 Seagate USB 3.0 External Drive Thermalright Venomous X Windows 10 Pro x64 
MonitorPower
3x 22" Dell Ultrasharp Corsair CX500 
CPUMotherboardRAMHard Drive
amd a10-7700k ASrock FM2A88M-HD+ Corsair Dominator 2x2GB Toshiba 
Hard DriveHard DriveHard DriveHard Drive
Toshiba Western Digital Green Western Digital Black Western Digital Green 
OSPowerCase
Windows Professional 8.1 OCZ 650W Antec 300 
  hide details  
Reply
Main PC
(10 items)
 
File Server
(11 items)
 
 
CPUMotherboardGraphicsRAM
i5 2550k ASUS Maximus V GENE EVGA GeForce GTX 660 Ti+ 3GB w/Backplate 16GB Kingston Hyper-X 
Hard DriveHard DriveCoolingOS
2x Kingston HyperX 3K RAID 0 Seagate USB 3.0 External Drive Thermalright Venomous X Windows 10 Pro x64 
MonitorPower
3x 22" Dell Ultrasharp Corsair CX500 
CPUMotherboardRAMHard Drive
amd a10-7700k ASrock FM2A88M-HD+ Corsair Dominator 2x2GB Toshiba 
Hard DriveHard DriveHard DriveHard Drive
Toshiba Western Digital Green Western Digital Black Western Digital Green 
OSPowerCase
Windows Professional 8.1 OCZ 650W Antec 300 
  hide details  
Reply
post #6 of 9
step 1 you copy as it is, step 2 you would change "master" to the name of your database, and select F,D or L as your backup type. If you dataset is small, I'd just still with full, easier to deal with if you need to restore. You can always compress them after the backup runs to save space.
post #7 of 9
Why not just use osql and backup the DB through the Windows task scheduler?
    
CPUMotherboardGraphicsRAM
Q9550 stock Intel DP35DP 8600 GTS Extreme Overclock 8GB DDR2-800 
Hard Drive
2x Intel X25-V RAID-0 and 1 Seagate 750GB SATA 
  hide details  
Reply
    
CPUMotherboardGraphicsRAM
Q9550 stock Intel DP35DP 8600 GTS Extreme Overclock 8GB DDR2-800 
Hard Drive
2x Intel X25-V RAID-0 and 1 Seagate 750GB SATA 
  hide details  
Reply
post #8 of 9
Quote:
Originally Posted by Peanuthead View Post
Why not just use osql and backup the DB through the Windows task scheduler?
Hey. The Windows task scheduler promises you nothing. I mean, this is no guarantee for anything, either the safety of your data or the integrate of the image.
At this point, I recommend try some third-party software to do the schedule backup work, such as Acronis, Parogan, EaseUS, and Macruim, etc.
Acronis and Parogan are the top leader in the field, but if you choose something cheap and fine, I recommend you easeus backup better than Macruim.
post #9 of 9
For database disaster recovery, I think it is better to choose one reliable solution. There are many backup software on the market, acronis, to do backup, Nova. I have test the trial of todo backup, it offers one-click recovery system disk after disaster solution and advanced backup scheduler you can check one which are versatility and relatively cheaper.
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Servers
Overclock.net › Forums › Specialty Builds › Servers › Scheduling backups with SQL Server 2005 Express