I am doing the below : RESTORE DATABASE UAT FROM DISK = ‘E:\Databases\backup\MY_LIVE_20120720_070001.bak’ WITH REPLACE But I want to be able to use a file location that ignores the numbers in the file name (which represent the date) in my back up file. There will only ever be one ‘MY_LIVE_****.bak’ but its number string will change each day. The goal is to restore my UAT instance from live each week, using the latest backup – [...]

While preparing to move to a new house, I came across two forgotten tape backup mini cartridges from 1996. I know they hold the only backup I made of my original Remote Access BBS, with all my original Star Trek themed ANSI art, DOS/OS2 shareware, and 1000+ users. I’d love to be able to resurrect this time-capsule, but what hardware device can actually read this? I think I originally used a 50pin Wide-SCSI external backup, [...]

We’ve got a Dell T610 Server with SBS 2008 on it, running Exchange Server, SQL Server Express, DHCP, Active Directory, Sharing Files and Printers, etc. We currently have (4) Seagate Savvio 15K 146GB hard drives in RAID 5 on a PERC6/i RAID controller. There are two separate Windows partitions on a single Logical Drive. The first partition (Disk0) is 100GB and holds the Operating System and applications. The remaining space (about 450GB) is the second [...]

If I have two instances of Sql Server 2008 R2. One is standard edition, one is web edition. If I take a backup of a database from the standard instance can I restore it to the web edition instance? Asked by Mike Q As long as the version is the same (“SQL Server 2008 R2″), you can restore back and forth between the two servers however you like. The edition (“Standard”, “Enterprise”, “Web”, “Developer”) of [...]

I’m more of a developer, but I have a Dev Environment I’m creating at home for a personal project. I want to install Server 2008 R2, SharePoint 2010, VS2010, and then take a snapshot of the hard drive, so if I ever nuke the machine I can restore it to this state without having to install OS, Server, VS2010, and then patch the whole thing. Is there a free software suite that does this? Is [...]

how can i clone a server onto a remote drive? I would like to make an identical backup of my CentOS 6 64bit server onto a remote hdd. I am going to be installing a raid card into the sever causing all data to be erased. I want to be able to backup the server then clone back the data as if the server was never touched. How can i do this? I am on [...]

As said in the topic I need some help restoring a database to a new server. There is a production database on one server – I do a daily automated backup of that database to a remote location: pgdump, binaries, and bzipped logs. Now I want to create a test environment on the other server running a copy of that database. Could you please tell step by step me how to recover it? I read [...]

This is not a good day for me. I have a backup (master.bak) for SQL Server 2005 Express SP4 (v.9.0.500) that I want to restore to my master db instance. I am running SQL Server in single-user mode (sqlservr.exe -m), connect to the instance, then I do a Task… Restore. This is the error I get: TITLE: Microsoft SQL Server Management Studio Express Restore failed for Server ‘GINOSQLEXPRESS’. (Microsoft.SqlServer.Express.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476 —————————— ADDITIONAL [...]

I am trying to restore my OpenLDAP server from an ldif file I made before it went horribly wrong. All of the websites I found talk about using slapadd but when I run slapadd -v -l ~ns01/openldap_config.ldif it returns the error Could not stat config file “/etc/ldap/slapd.conf” : No such file or directory (2) slapadd: bad configuration file! When I look in the directory indeed the file does not exist, but this is because Ubuntu [...]

In the process of creating an automated solution for backing up and restoring an entire MySQL server, I’ve come across the mysql database which seems to contain user accounts, permissions, metadata, that kind of thing. Should this database be backed up? Will backing up and attempting to restore it break things? I’ve had a heck of a time Googling for “mysql backing up mysql database” as you can imagine. Here is something interesting to consider: [...]