Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [database-backup]

251 questions
0
votes
1 answer

Error in backup query of SQL Server

I have a database in SQL Server and I want to create backup from it to a shared folder. just one of the network users has permissions to access to this folder. I have written a code to log on this user at the middle of my program and then execute…
M_Mogharrabi
  • 21
  • 1
  • 4
0
votes
2 answers

Keeping two servers in sync - secondary server only to be booted for the backup, or in outage

I've just started a new Software Development job but I've basically been given loads of sysadmin stuff to do because the development team consists of only 2 people + the CTO. I've got pretty much zero experience with kind of stuff and focused mainly…
sxthomson
  • 101
0
votes
1 answer

MySQL database backups to a local server

We have a backup system at the moment, but after a recent scare, we’d like another backup of just the MySQL databases, nightly, to a local server in our office. The databases are pretty big as it stores a lot of different ecommerce stores. To make…
Zoe Edwards
  • 133
  • 3
0
votes
1 answer

Server restarted when I take database backup in SQL Server 2008?

I have 10 databases in my SQL Server 2008. If I take a database backup, 8 databases are working just fine. When I take database backup for the remaining two, at 50% of backup of process, the server automatically restarted. So I am not able to…
kanth
0
votes
1 answer

backup berkeley db (java edition)

At the moment I am backing up my Berkley DB databases by taking hard copies of the log/db files periodically. The problem with this approach is that I run out of disk space quite quickly. Is there a way of creating incremental backups, analogous to…
murungu
0
votes
1 answer

Oracle 10g Failover Database - How to fail back?

I want to know how the failover database concept works after recovery. We have defined our application to connect to a backup database in case the production database fails. If this happens, then all the transactions will be happening on that backup…
rrkwells
  • 1
  • 1
0
votes
1 answer

Does SQL Agent need to be running in order to take manual SQL backups?

If we have a situation where SQL Agent fails to start, will we still be able to take a full manual SQL backup? I don't mean scheduled backups and maintenance plans, just plain Right Click > Tasks > Backup (in SQL Management Studio).
TimS
  • 338
  • 2
  • 3
  • 13
0
votes
2 answers

SQL Server backup

I have Full-Backup-A Transaction-Log-Backup-A Transaction-Log-Backup-B (*) - I have to restore this point Full-Backup-B How to do it? It seems that the only way is Full-Backup-A Transaction-Log-Backup-A Transaction-Log-Backup-B Shut-off client…
zzz777
  • 101
  • 3
0
votes
2 answers

SQL Server 2008 import data from SQL Server 2005 backup file

I have a SQL Server 2005 database backup file (.bak), and I want to grab the data of this file and import it to an already existing database. Since the backup file contains database information as well, a simple Restore doesn't seem to work -…
Björn
  • 135
  • 1
  • 6
0
votes
2 answers

automatic mysql backup in windows server 2003

someone Know and can recommend me an open source program or freeware software to realize automatics backups in mysql under windows server 2003. I need automatize a task every day. A shareware program for that is …
Mak
  • 15
  • 1
  • 1
  • 3
0
votes
4 answers

How to create empty database from existing one (Mysql)

I have a mysql db with many tables. I'm starting a new farm which should contain empty versions of the same database tables. How can I efficiently create empty database based on existing one?
Niro
  • 1,401
  • 4
  • 20
  • 36
0
votes
7 answers

How do I run SSH to my web server using PHP?

I am backing up my database using mysqldump as I read here: http://www.tizag.com/mysqlTutorial/mysqlbackup.php It gives me some sort of command(Linux I think): mysqldump --tab=/path/to/some/dir --opt db_name But it doesn't explain what I do with…
zeckdude
0
votes
2 answers

Running sql server 2000 backup file on sql server 2008

I restored sql server 2000 .bak file to sql server 2008 by --RESTORE FILELISTONLY --FROM DISK = 'D:\DBHarshal\full backup august 6.BAK' --ALTER DATABASE EPICSms --SET SINGLE_USER WITH --ROLLBACK IMMEDIATE RESTORE DATABASE EPICSms FROM DISK =…
hrishi
0
votes
1 answer

Maintenance Plan Reporting - Append To File - Clean Up?

Background: (SQL Server 2005, Standard Ed.) I have a maintenance plan running backups, taking a full backup 1/day, and t-log every 15 minutes. I have it set to create a text file report of each run, but that creates A LOT of files on the file…
Adam J.R. Erickson
  • 147
  • 2
  • 6
0
votes
1 answer

How to do a database backup in DB2 in Vista?

How to do a database backup in DB2 in Vista? Whenever I issued this command (login in Vista as Administrator): restore database myDB from D: taken at 20081013134446 the command line processor return the following error message: SQL1092N …
Muhammad Hewedy
  • 101
  • 5
1 2 3
…
16 17