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
Solved

Automatic backup in SQL Server Express

Posted on 2011-09-23
7
209 Views
Last Modified: 2012-05-12
How can do the Automatic backup in SQL Server Express ?
0
Comment
Question by:egovernment
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
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL 2008 R2 syntax 11 35
SQL Server 2012 r2 Make faster Temp Table 17 113
SSRS Subscription jobs disabled, yet still running 4 49
SQL Recursion 6 16
After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …

807 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