Tag Archives: Backup

SQL 2012 DPM Backup Failure – The SQL Server instance refused the connection

Posted by dave on May 6, 2013 No comments

Some of my DPM Backups on a new 2012 box were failing with the error The fix can be found here and is pretty straight forward. Add the account NT_AUTHORITY\System to have sysadmin priviledges within SSMS. Once added you should receive no more …

Exporting Mailboxes to PST’s using Powershell in Exchange 2010

Posted by dave on October 5, 2012 No comments

As part of a user leaving, I decided on protocol to backup their mailbox to a PST before deleting their mailbox from Exchange, just incase. This can be achieved very easily with a bit of powershell.

New-MailboxExportRequest -Mailbox user.name -FilePath \\server\folder\user.name.pst

1	New-MailboxExportRequest -Mailbox user.name -FilePath \\server\folder\user.name.pst

The full instructions …

SQL Backup and Restore Commands

Posted by dave on July 22, 2011 No comments

Some useful code snippets for backing up and restoring data in MS SQL. Create full backup: (also output times for reference) select {fn Now()} as ‘Start Time’ BACKUP DATABASE DBNAME TO DISK = ‘d:\DBNAME.bak’ WITH INIT select {fn Now()} as …

mySQL Restore Batch File / Script

Posted by dave on July 4, 2011 No comments

I got bored typing mysql commands so wrote a little script to keep on my box for easy access to restore databases from .sql files. It’s very simple and may not be any use to anyone. It also stores the …

3G WAN Failover using PFsense and the Edimax 3G-6200nL

Posted by dave on June 21, 2011 No comments

We’ve had a few internet issues lately in the office, mostly occurring late in the afternoon when the internet will just drop. I’ve been on the phone to Zen a lot and the cause is noise on the line, but …

Script to 7-zip all files and then delete the originals

Posted by dave on November 22, 2010 No comments

I wrote a while back about a script which would go through my backup directory and 7-zip my .bak and .sql files and then delete the originals, so that they were much smaller to then backup to my elephant drive. …

Moving and Sharing Files with Dropbox

Posted by dave on September 6, 2010 No comments

I came across a handy service today called Dropbox. You can download it here, for free. It’s a great way to sync files between your many devices (PC, Laptop, Netbook, Mac, PDA etc). It creates a folder in your “My …

Restore a MySQL Database Backup from the .sql File

Posted by dave on May 11, 2010 No comments

I’ve written a bit on backing up data and have been asked how to restore data to MySQL. Pretty simple, assuming you have your backup file, just run: “C:\Program Files\MySQL\MySQL Server 5.0\bin\mysql.exe” -uUSERNAME -pPASSWORD DATABASENAME < “c:\BACKUPFILENAME.sql” On the box …

dave.harris.net

Sysadmin and part time Gadgeteer

Tag Archives: Backup

SQL 2012 DPM Backup Failure – The SQL Server instance refused the connection

Exporting Mailboxes to PST’s using Powershell in Exchange 2010

SQL Backup and Restore Commands

mySQL Restore Batch File / Script

3G WAN Failover using PFsense and the Edimax 3G-6200nL

Script to 7-zip all files and then delete the originals

Restore a MySQL Database Backup from the .sql File

Categories

Sysadmin and part time Gadgeteer

Tag Archives: Backup

Tag Cloud

Categories