Solved

Automatic backup in SQL Server Express

Posted on 2011-09-23
7
210 Views
Last Modified: 2012-05-12
How can do the Automatic backup in SQL Server Express ?
0
Comment
Question by:egovernment
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 8

Expert Comment

by:venk_r
ID: 36588977
Use the below script

DECLARE @Path NVARCHAR(1000), @FileName NVARCHAR(255), @FullPath NVARCHAR(1255)
SET @Path = '\\db1\E$\SQLServer\2008\Backups\'
SET @FileName = 'Express_' + REPLACE(CONVERT(VARCHAR(10), GETDATE(), 101), '/', '') + '.bak'
SET @FullPath = @Path + @FileName

BACKUP DATABASE Express
TO DISK = @FullPath
WITH INIT

And scehedule them using SQL JOBS

0
 
LVL 59

Expert Comment

by:Kevin Cross
ID: 36589106
SQL EXPRESS edition does not have SQL Agent; therefore, you cannot schedule it that way. Now you, could create a .SQL file containing the code above that you run through SQLCMD.exe. You can try to schedule that using Windows Scheduled Tasks.
0
 
LVL 59

Expert Comment

by:Kevin Cross
ID: 36589109
0
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 
LVL 8

Expert Comment

by:venk_r
ID: 36589323
I agree.
0
 
LVL 70

Accepted Solution

by:
Éric Moreau earned 500 total points
ID: 36600174
0
 
LVL 1

Expert Comment

by:Field Marshall Bob
ID: 36600187
I have multiple small DB's I backup with the method mwvisa1 suggested.
0
 

Author Comment

by:egovernment
ID: 36983843
I will review the all answers
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question