The tag has no wiki summary.

learn more… | top users | synonyms (1)

0
votes
1answer
137 views

Can you a virtual service account access the network in workgroup

By default SQL Server Uses a virtual account for the sql server service: NT SERVICE \ MSSQLSERVER which is a Virtual Account. I know you can give this account nework access in a domain by adding ...
1
vote
1answer
192 views

Database backup with T-SQL script - Issue with Declare and Set Variables

Can someone tell me why I can't backup my database with the script below? I can run the script but it didn't create the backup. I"m using SQL Server 2008 DECLARE @pathName NVARCHAR(512) SET @pathName ...
1
vote
1answer
1k views

SQL 2008 Backups to UNC Share Failing 0xC002F210

This problem is driving me NUTS!! We take backups of all of our production databases to a network share, which are then backed up to tape nightly. 8pm Mon-Fri - Full backup, followed by log backup ...
0
votes
2answers
140 views

Differential backup of new sql database fails until full backup is made

I have setup a job that runs every night and makes a full backup of all databases on the server. During the day, another job makes differential backups every few hours. The problem comes when a new ...
2
votes
1answer
211 views

Using mongodump with an auth enabled mongodb server

I'm trying to do a daily backup of my mongodb server (auth enabled) using the mongodump tool. mongodump provides two parameters to set the credentials: -u [ --username ] arg username -p [ ...
1
vote
1answer
127 views

Minimum mysql wait_timeout?

On a hard-hit database server which ofter suffers from maximum connections being saturated, mysqltuner.pl suggests me to set wait_timeout (< 1) I am wondering whether it would be wise to ...
0
votes
1answer
864 views

SQL Server 2012 Maintenance Plan succeeds but does not perform backup

I have a new SQL Server 2012 AlwaysOn Availability Group on Windows Server 2008 R2 Ent SP1. I'm creating a Maintenance Plan on the Primary Replica which is supposed to do Full (non-copy-only) backups ...
2
votes
1answer
250 views

Postgresql 9.0.8 Physical Backup on Windows Server 2008 R2 results in “Access is denied”

I've built a script to perform a physical backup of a Postgresql 9.0.8 database by following the "Standalone hot physical database backup" recipe in the PostgreSQL 9 Administration Cookbook ...
2
votes
2answers
926 views

Encrypting Amazon EBS Snapshots

Would love it if someone could help me out with this: The setup is a distributed LAMP architecture hosted on Amazon EC2 instances. MySQL Percona. We use Amazon's EBS snapshots for backups. We have ...
1
vote
1answer
755 views

How to export database from Oracle 10g

I'd like to export database with all the triggers, indexes, grants and user accounts from Oracle 10g database. Problem is I only have SYSDBA access to the server, so I can't access the servers files ...
8
votes
3answers
2k views

Do InnoDB tables got locked during mysqldump when mixed with MyISAM?

I'm looking for a backup solution for my mysql servers and I need as less downtime as possible. I have the following: MySQL servers they are not replicated each server stands for its own This ...
0
votes
1answer
313 views

MySQL in amazon AWS: backup and disaster recovery - EBS snapshots v/s RDS

I will be uploading a web application to amazon ec2 instance in the next couple of weeks. I am using : windows server 2008 r2 64 bit as an amazon instance along with a 30 GB EBS. The only confusion i ...
1
vote
3answers
319 views

Backing up data (including mysqldumps) to S3

We have a web app on a number of servers and we want to add an additional layer of redundancy by backing up the key data to S3. The key data is the MySQL database and a folder containing dynamically ...
2
votes
2answers
94 views

How to back up a database with thousands of files

I am working with a Fedora server that runs a customized software package. The server software is quite old, and its database consists of 1,723 files. The database files are constantly changing - ...
2
votes
3answers
949 views

How can I split phpmyadmin's server backup to database backups?

I have a big .sql file which i created with phpmyadmin to back up my development databases. is there any way to split this big backup into several files, each file for a separated database? the file ...
1
vote
4answers
1k views

Mysqldump causes “Too many connections”

A scheduled backup using mysqldump on one of our databases is causing Too many connections. The database is of both InnoDB and MyISAM tables with size of around 500Mb. The Too many connections appears ...
1
vote
2answers
175 views

Does Plesk 9 (CentOS) do a MySQL database dump of all databases each day?

Anybody know? At the moment I've been looking into setting up something running via CRON to do this but if Plesk already does it 'behind the scenes' then I don't want to add unnecessary tasks to the ...
0
votes
2answers
65 views

Moving database to new server

I'm restoring a backup of a production database to a new server. The new server also hosts the application which makes use of the database. As such I'd like to use the same user/pass combination to ...
1
vote
1answer
107 views

If I have Postgres streaming replication on, do I still need to archive my WAL files?

I have set up two servers running Postgres 9.1, with one configured as a hot standby for the other using streaming replication. Given that, is there any reason for me to be archiving my WAL files? ...
2
votes
1answer
465 views

Consistency of virtual machine backups using ghettoVCB

I have a ESXi host with both Windows and CentOS virtual machines running. A couple of them are running SQL Databases (MSSQL and MySQL). I am trying to setup a backup strategy using the ghettoVCB ...
-5
votes
2answers
2k views

Possible to just “copy” Active Directory database and files for a backup?

I know it's possible to use system state, but I do not want to do a full system backup... I want to backup AD and that's it. Would stopping all AD services, then backing up all NTDS files be ...
2
votes
2answers
400 views

How to store 250TB of data and develop a backup/recovery plan? [closed]

I'm really new to this topic, so big apology for stupid questions. I have a school project and I want to know how to store 250TB of data with life-cycle for 18 months. It means every record is ...
0
votes
1answer
1k views

How to schedule a backup in Plesk for Database and configuration?

I like to make a scheduled backup in plesk 10.4. My target is to Take the backup of Database and configuration and put in the FTP location. I dont see any option in backup manager in plesk. Any ...
0
votes
1answer
475 views

SQL Server Agent job fails to backup to remote folder

I have created a SQL Server Agent job (in SQL 2008 R2) to back up some databases on a server. This task runs fine when the backup folder is set to a folder on that machine, but when I try to set it to ...
1
vote
1answer
78 views

Backups from MySQL slave server — Good idea or bad?

I'm have one MySQL master and two MySQL slaves set up to replicate. I'm running my database backup process, consisting of an Xtrabakup (via the perl wrapper Innobackupex) backup and an atomic ...
1
vote
5answers
437 views

Mysql large database backup

How can I backup a large database in mysql? Folder size of Database is more than 5GB & contains 1.5 Lakh tables. I have tried to backup server through phpmyadmin but no luck.
0
votes
1answer
231 views

SharePoint Sites go into read-only when SQL Server Backup is running

I have SharePoint 2007. When the database backups run using SQLCMD, SharePoint sites go into read-only. Users can't add anything to the sites and the buttons are grayed out. On the backend the ...
1
vote
1answer
186 views

Backing up SQL backups on a network share

Currently I have Maintenance Plans configured to backup SQL Server databases to local drives, then the files are picked up by Commvault nightly, and my SQL server maintenance plan deletes the backup ...
0
votes
2answers
640 views

CentOS Postgres, Backup/Restore

We recently inherited a company and their CentOS server with a Postgres running their CSR db. They have a backup system in place which we know nothing about. It creates backups of the Postgres DB in ...
2
votes
2answers
233 views

Is backing up to a NAS over private fibre link better than tape?

I have recently taken over the responsibility of a small business network of 35 users. I am a bit green on backup strategies and am considering my options. We currently backup our SBS Server to tape ...
0
votes
2answers
1k views

How to make pg_dump less resource greedy

I have configured cron to invoke pg_dump on a daily basis using following rule: # xyz database backups: 00 01 * * * root umask 077 && pg_dump --user=xyz_system xyz | gzip > ...
3
votes
1answer
127 views

SQL Server backups - transferring between instances

I work in a development shop where we primary use SQL Server for our day-to-day development and testing. Sometimes issues occur on someone's machine, often a labtop, that I would like to reproduce on ...
1
vote
1answer
189 views

Strategy to take cloud (amazon aws) backups

I need to take different type of backups(code backup, database backup, user uploaded files backup) from amazon instances, I need to make sure this backups are running properly and if any backup fails ...
0
votes
1answer
252 views

MSSQL techniques to archive-backup content

We are now moving from a MySQL to a MSSQL 2008R2 database. As the project is a web application that we need to be able to scale well, we need to rework the way the DB handles data. We have 3 separate ...
1
vote
1answer
35 views

Individual Customer Backup from Multi Customer DB

We have a multi customer database, that's about 95gb in size. One of the customers is requesting a monthly backup of their data. We have a script that strips out all records from all tables that are ...
0
votes
3answers
76 views

How to warehouse data that is not needed from MS SQL server

I have been asked to truncate a large table in MS SQL Server 2008. The data is not needed but might be needed once every two years. It will NEVER have to be changed, only viewed. The question is, ...
0
votes
1answer
57 views

Windows based Mogo database running on EC2 backups

Currently we have a windows 2008 server running a Mongo database hosted on Amazon EC2. Without looking at database replication to another database what can we do to make sure the database is getting ...
1
vote
3answers
1k views

How can I delete SQL Server differential and log backups earlier than the earliest full backup still on disk?

When I delete a full backup, I would like to delete all the files that are rendered useless once that full backup has been deleted: specifically, the differential and log backups that occur before the ...
0
votes
1answer
2k views

Auto backup mysql database in phpmyadmin

Can i backup the mysql database automatically every week like scheduled job in local Phpmyadmin. if possible i would like to take the each database separate file.Is this possible ! Thanks
1
vote
2answers
382 views

What's the most efficient way to reclaim disk space after deleting lots of data from a database on Sybase ASE 15?

As I understand it, based on some research but zero real-world experience with Sybase ASE, the only way to reclaim disk space once it's been allocated to a database is to export that database, create ...
3
votes
2answers
336 views

Duplicating an ESXi host to another ESXi host as a backup solution

I have an ESXi host with the following virtual machines: 1 x Active Directory Server 1 x Remote Desktop Services Server 1 x SQL Database Server 1 x Accounting Software Application Server I have a ...
1
vote
2answers
114 views

Is it possible to export a database without its Users?

Is it possible to export a SQL Server database (data, structures) without its users ? If yes, is it possible using SSMS ?
-1
votes
1answer
160 views

Backup and Restore MySQL database

need backup MySQL 5.1 databse. Database is install on Windows Server 2003. I google it and I found many tools but I am little confuse what choose. My requirments are: Tool for backup must have a ...
0
votes
1answer
259 views

shell script won't work in cron

I have very smiple script to do a backup, and it is working fine when I run it from the command line, but I am having problems running it as cron job. My cron entry is this: (running it every minute ...
2
votes
1answer
402 views

Cleanup Backup Files without xp_cmdshell or maintenance plans

Background: We've got a backup script which needs xp_cmdshell to run. I decided that on new servers, we are not going to enable xp_cmdshell. I enabled xp_cmdshell when the job starts and turn it ...
10
votes
4answers
2k views

Should I backup and restore the `mysql` database?

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, ...
12
votes
6answers
1k views

Downtimeless MySQL backups on a budget

My current MySQL backup scenario is to replicate our db to a second server and run mysqldump on that server to remove any downtime from table or row locking. This is working well but costs $150 per ...
1
vote
3answers
3k views

Backup SQL Server DB to a remote drive

I am trying to backup a SQL Server database to another drive letter located on another network on another domain. The location has already been mapped to Z:\ and corresponds to \\10.98.76.6\Backups\. ...
0
votes
1answer
179 views

SQL Server 2005: Row in backup, missing in database

I've got a MS-SQL 2005 backup file. When I open with a text editor, despite being binary, I can see some information I want back. Nevertheless, when I restore the backup using MS-SQL studio, the row ...
0
votes
1answer
79 views

automatic backup [duplicate]

Possible Duplicate: how to get database backup automatically i want to have automatic backup in my program.it means that for example every 30 minutes a table that contains backup schedules ...