I created a document management system for a client which uses SharePoint and SQL Server to store PDF documents. Due to some SAN misconfiguration 3 disks that were holding both MDF and LDF database files dissapeared from the OS one day. We are in the process of recovering the data of the SAN but my question is how do I detach an existi...
I'm using multiple Linux laptops/desktops and want them to "share" home directories. NFS is unfortunately not an option. Therefor I was trying to create a bash script using rsync but I can't figure out how to do it. This is my example right now #!/bin/bash sync() { rsync -azvR --exclude-from=/home/ME/.rsync_excludes --delete -e 's...
Hi All, I have just finished developing an ASP.NET on my local Windows XP machine. I used Visual Studio 2008 and SQL Server express to develop the site. My problem is that now I would like to move the SQL Server database from my XP machine to my production server. I have been reading that SQL Server express cannot export my database. ...
I have a DB I created with SQL Server 2005 and created a backup (*.bak) now I want to restore it with 2008 but ouch, I get the following error: TITLE: Microsoft SQL Server Management Studio ------------------------------ Restore failed for Server 'SHIMMY-PC\SQLEXPRESS'. (Microsoft.SqlServer.SmoExtended) For help, click: http://go.mic...
Getting this error in our log report for WHM backups. Copying homedir..../bin/gtar: ./public_html/webmail/SQL: Cannot stat: Permission denied /bin/gtar: ./public_html/webmail/config: Cannot stat: Permission denied /bin/gtar: ./public_html/webmail/logs: Cannot stat: Permission denied /bin/gtar: ./public_html/webmail/program: Cannot stat:...
Hi there, I have two database servers running SQL Server 2005 Enterprise that i want to make one of them as mirror database server. What i need is, create exact copy a database from primary server on mirror server, so when the primary server was down, we could switch database IP on application to use mirror server. I have examined "mi...
Hello all! I'm trying to write simple application in C# which will allow me to backup, zip and send over ftp my SQL Server database. One problem I have encountered is that I'm not able to create the backup file (.bak) if I try to do it in different location than "C:\Program Files\Microsoft SQL Server\MSSQL.3\MSSQL\Backup" or "C:\Program...
I have a SQL Server 2005 database that is backed up nightly. There backup consists of: 1 FULL backup of the database. 1 backup of the transaction log. These are currently two separate jobs. The log is huge and I'd like to set things up so that: 1) the database is backed up in full nightly 2) the log is set such that I can recover the...
I'm an absolute newbie when it comes down to subversion and SVN (don't even know the difference). As I'm developing a pretty big website I'm looking for a way to take care of different versions (PHP, CSS, JavaScript files and MySQL database) and to make backups. I would like to use a web based system so I have an external backup. I'm not...
I would like to make a complete backup of my whole joomla 1.5 based site from time to time. How would this ideally be done? Are there any common pitfalls? Not that I only have ftp access to the hosting server. Is there a step by step tutorial somewhere? I am using latest Joomgallery and Kunena 1.0.9 (Legacy mode). Maybe there is a good ...
Hi there, Can anyone let me know what is the best practice for doing sql server backups i.e. FULL, differential and partial differential I will doing this from code using SMO (c#) but anyway... is it best to do a FULL backup every 1 month and a differential every day?? Just looking for a bit of guidance really Any ideas? ...
Hi Guys! I'm working on some documents on a laptop which is sometimes offline (it runs winXP). I'd like to backup automatically the documents to a folder to a remote location so that it runs in the background. I want to edit the documents and forget about backuping and once online - have it all backuped to a remote location, or even be...
I'm currently learning Qt and have decided to write a little application to backup important documents each month to DVD. My current design makes use of the 7zip library along with cdrtools (mkisofs and cdrecord) to compress the directories into a spanning zip archive comprising of zip files each the size of a DVD and then use mkisofs to...
Does anyone have recommendations on a good (and especially cheap) way to take image-based backups of a handful of different machines? Products like Acronis are way too expensive for me. I've heard good things about Windows Home Server as an image-based backup tool, but I'm leery of using WHS to back up a production server. Has anyone ...
I am looking for a hot backup system for mysql databases? I like to ask you for experiences and expertise. ...
Current situation: Ubuntu 8.04 server edition (live server) Postgresql 8.3.7 (from standard repositories) Postgis 1.3.3 (from standard repositories) GEOS 2.3.4 (from standard repositories) Problem: GEOS contains bugs which are fixed in the 3.0 release. I have encountered these and need to upgrade GEOS/Postgis to include the GEOS...
I have an MSDE 2000 database backup file which is appending rather than deleting or renaming. I am using this command: BACKUP DATABASE [SPSDB] TO DISK = 'E:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\SPSbackup\spsdb.bak' with retaindays = 1 I am using a maintenance plan on my full SQL version databases, and they create a new file...
I'm setting up a SQL Server 2008 server on a production server, which way is the best to backup this data? Should I use replication and then backup that server? Should I just use a simple command-line script and export the data? Which replication method should i use? The server is going to be pretty loaded so I need an efficent method. ...
We're running a CentOS server with a lot of MySql databases atm, what I need is a really easy way for us to back those up. Since many of them are under a couple of meg. Dumping, zipping them up then sending them to a secure Google Apps account sounds like a pretty good idea. So what I need is: a script that will dump and zip the databas...
Please give me some hints on my issue. I'm building a queue data structure that: has a backup on hard disk at realtime and can restore the backup Can respond to massive enqueue/dequeue request Thank you! ...