Solved

SQL Express 2014 - Script to backup transactions

Posted on 2016-08-30
8
85 Views
Last Modified: 2016-09-05
WE have a SQL Express installation for a product and we need to find a way to backup the logs every 2 hours.
What's the best way to achieve this using?

Thanks.
0
Comment
Question by:BJMagill
[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
  • 4
  • 3
8 Comments
 
LVL 34

Accepted Solution

by:
ste5an earned 500 total points
ID: 41777641
Use scheduled tasks to run a backup script using sqlcmd or PowerShell. See Back Up a Transaction Log (SQL Server).
0
 
LVL 4

Expert Comment

by:Daniel Jones
ID: 41777959
0
 
LVL 34

Expert Comment

by:ste5an
ID: 41778032
@Daniel: SQL Express has no SQL Server Agent who executes scheduled jobs.
0
Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

 

Author Comment

by:BJMagill
ID: 41784377
ste5an, outstanding reply however I'd like to be able to apply a date and time stamp. Not sure how to accomplish this using the Powershell script:

Here's what I have..
Backup-SqlDatabase -ServerInstance uuaesrv01\sqlexpress -Database AstaPP -BackupAction Log

Thanks,
0
 
LVL 34

Expert Comment

by:ste5an
ID: 41784383
How do you invoke it? Do you get any error messages?

btw, does your database run in full or bulk-logged recovery mode?
0
 

Author Comment

by:BJMagill
ID: 41784396
Full mode.....
No error. It just writes the backup file as below:
Details
0
 
LVL 34

Assisted Solution

by:ste5an
ste5an earned 500 total points
ID: 41784565
So you mean by timestamp to add it in the file name?

Use the BackupFile parameter.
0
 

Author Comment

by:BJMagill
ID: 41784594
Yup,

That's the job.

So, for anyone that is interested... here is the finished version.

$currentdate = get-date
$currentdate = $currentdate.ToString('MM-dd-yyyy_hh-mm-ss')
Backup-SqlDatabase -ServerInstance uuaesrv01\sqlexpress -Database AstaPP -BackupAction Log -BackupFile AstaLog$currentdate.log

Thanks.
0

Featured Post

Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

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

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

737 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