Making copies of data which may be restored after a data loss event or to recover data from some earlier point in time.

learn more… | top users | synonyms (1)

0
votes
0answers
96 views

Backup is getting failed with following error

Msg 3202, Level 16, State 1, Line 1 Write on "\w-mum-fp\SQLBKP\Weekly-FL\Interactions_26_01_2014.bak" failed: 1130 (Not enough server storage is available to process this command.) Msg 3013, ...
0
votes
2answers
349 views

I can't import my database into mysql

I have a website based on drupal and I tried to export its database via both Backup wizard and phpmyadmin. the database was exported but I can't import it on my localhost database.this the error ...
0
votes
0answers
909 views

Oracle EXP Error ORA-12704: character set mismatch

I need to duplicate a Oracle 11g Express Edition database from one computer to another computer. I tried exp sys/password FULL=Y FILE=backup.dump (the idea is to do a imp on the other pc) But it ...
0
votes
0answers
477 views

Database backuped, but “Last database backup” property shows bad date

I have this procedure below to backup database(procedure is in backuped database). Procedure is called by external program. Procedure runs fine, backups are created. But when I want to find out last ...
0
votes
0answers
164 views

Recommended plan for 0min RTO and RPO

I have a Windows Server 2008R2 Server, running SQL Server 2008R2 SP2. The server currently only does a full backup once daily. The server's operational hours are between 8am and 5pm. The server's new ...
0
votes
0answers
104 views

Backup in Mysql periodically

I have trouble scheduling a backup in mysql periodically, most of the tools do not recognize the geometric field, for example navicat which says Can not get geometry object from data you send to ...
0
votes
1answer
531 views

Backup/Restore File Groups SQL Server [duplicate]

I've got a database with 3 Filegroups and each filegroups own a single file, Filegroup names are Primary, SecondFG and ThirdFG. I want to backup ThirdFG separately each time without backing up the ...
0
votes
2answers
163 views

Backup certain tables in MySQL [duplicate]

Is it possible to take backup of certain table in mysql? Suppose I have 10 tables, and I want to take a backup of 8 tables through one command. How can I do this?
0
votes
0answers
922 views

Is it recommended to run a Oracle schema backup when there are active sessions?

I need to backup two schemas in a Production database (Oracle11gR2) that are being accessed by an application and some other systems. These schemas are quite small and exp will be used for the export. ...
0
votes
0answers
134 views

Tape rotation strategies

I am trying to find a tape rotation strategy that would be optimal under the following conditions: Backup Media Rotation strategy should support the following: Media Archives required ...
0
votes
0answers
35 views

Performing a Transaction Log Backup on a Live Database [duplicate]

I have a server 2012 database that has a transaction log that is growing at a rapid rate. i have a job that runs once a day after production hours which backs up the log file and shrinks it. The ...
0
votes
0answers
465 views

How to do point in time recovery of binary log files into .sql file

I have written a shell script to do an incremental backup of MySQL database. For point in time recovery I'm using the binary logs generated in /var/lib/mysql directory. For point-in-time recovery, Im ...
0
votes
2answers
57 views

MySQL Backup Strategy

We are running the backup from the replication server and it is working good, since we are not facing any other issues, some information for better understanding our strategy: Backup Type: Full ...
0
votes
1answer
128 views

Is possible do an online snapshot backup , without archive logs at Oracle Database?

Using Oracle Database Standard Edition 11r2 . I'm looking a way to backup the database with zero downtime , using a snapshot of datafiles (LVM snapshots) and without need backup de archive logs. ...
0
votes
1answer
176 views

SQL Server 2000 Backup fails with Status = 33

I am trying to take a Full Backup of a database size about 75GB. It is SQL Server 2000 - 8.00.2055 x86 version. I have plenty of disk space where the backup is being created. So disk space isn't an ...
-1
votes
2answers
67 views

Database BackupSize has Changed after migration from SQL Server 2012 Exterprise to SQL Server 2012 Express [closed]

I would like to say that after migration of MS SQL server 2012 Enterprise to MS SQL Server 2012 Express. I have seen there is some subtle diffence in DB backupsize as well as in "LSN" of all ...
-1
votes
5answers
261 views

I do not understand SQL Server Transaction Logs

I understand that a Microsoft SQL Server Database has two components: A database file A transaction log file Whenever I make a change to a table, does it get written to both the database file AND ...
-1
votes
3answers
65 views

Exclude databases from automatic full backup [closed]

I have 10 databases on my SQL Server. We do an Automatic Full Backup every day at 00.00. The issue is there are two databases out of the 10 that should not be backed up as these databases are ...
-1
votes
3answers
71 views

To take a full backup and differential backup of all databases

Can anyone help me with a script to take a full or complete backup of all databases once in a week and to take differential backups daily. ?
-1
votes
1answer
78 views

SQL Server database backup file is successfully created in a path but no such file path is available in my local machine

When I tried to take backup of SQL Server database, it was successfully created in C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Backup\ but no such path is available on my local ...
-1
votes
1answer
171 views

IO Frozen in error SQL error log

The log shows IO DBName is Frozen follow by thaw but yet my database schedule backup task which normally been running isn't since the network team are doing backs (not database backups, according to ...
-1
votes
2answers
2k views

How do I connect to a database with a blank password using a shell script?

## connect to mysql and source backup file ## USER="root" PASS="" mysql -u$USER -p$PASS database_name < backup.sql Above is my shell script which I used to source database but still its asking ...
-1
votes
1answer
42 views

Data warehouse backup strategy

I have a data warehouse development environment. Just as the production environment. it loads data every night from test OLTP databases. I want a backup every time the load process finishes. What ...
-1
votes
1answer
187 views

How to reduce the size of ldf file? [duplicate]

We take full backups of the DB every day (in full recovery mode) and keep them for 10 days. Because of our requirements, we don't want to take incremental or differential backups of the DBs. Now we ...
-1
votes
2answers
703 views

How to Find All SQL Server database back list in my system? [closed]

My SQL Server 2008 R2 system has different database backups on different drives like C:, D:, E: Now I would like to see all database backups listed in SQL Server 2008 R2. Thanks for your time
-1
votes
1answer
1k views

How to merge data from 2 databases [duplicate]

I have a SQL-Server database that crashed while I was away on vacation. All info from 5/2/13 is missing from our current database because my replacement implemented a back-up of the database from ...
-1
votes
1answer
226 views

Back up my ASPNETDB

I want to back up my database but I got this error: Cannot open database "ASPNETDB" requested by the login. The login failed. Login failed for user 'My-laptop\user'. I'm using SQL Server Express ...
-1
votes
1answer
339 views

Should I keep pg_xlog on the same disk as data if using disk snapshotting?

We're running on EBS volumes on EC2. We're interested in leveraging EBS snapshotting for backups. However, does this mean we'd need to ensure our pg_xlog is on the same EBS volume as our data? (I ...
-1
votes
0answers
16 views

Mirrored Backup or Disk to Disk Replicated Backup

What would be preferable? Performing a database backup and mirroring the backup to two separate locations as part of the backup process. or Backing up to disk to disk backup and replicating that ...
-1
votes
1answer
21 views

Restore DB script

I wrote this script for restore DB: declare @dir nvarchar(70), @year nvarchar(4), @month nvarchar(2), @day nvarchar(2) set @year = datepart(year,getdate()) set @month = datepart(month,getdate()) ...
-1
votes
1answer
357 views

“Backup mysql database by copying the data file even when MYSQL server is running” solution! Is there any problem for this backup solution?

I am using MYSQL-5.0.27 I have 2 exact same MYSQL folder "mysql-5.0.27-win32". One in the Virtual Private Server (VPS) & the other in Local PC. At the beginning, these 2 folders are exactly the ...
-1
votes
1answer
91 views

quick checkpoints for development mode

i'm a programmer, not a dba. i need a mechanism to quickly make a snapshot of a database (oracle 11g XE) before i run migration. migration changes data, grants, DDL (tables, triggers, lexers, views ...
-2
votes
2answers
2k views

Incremental backup in SQL Server [closed]

I got a task for backing up my clients data through internet. Client has about 50 GB of data there. So I need to back up the data and pass through internet, but it takes about 8 to 9 hours for this ...
-2
votes
1answer
63 views

Backup SQL Server database to the cloud or network folder [closed]

I can take a SQL Server backup to a local disk without any problem, but I now need to backup to a cloud disk or network folder that I can access. What are the best practices to do this?
-2
votes
1answer
64 views

I have created a zip file using 7z for backup but its taking time to open [closed]

I have created a zip file using 7z for backup but its taking time to open. Any possibility of making fast. Please suggest me.
-2
votes
1answer
63 views

Backup file from SQL Server 2012 to 2008 [duplicate]

I have a backup file of SQL Server version 2012 but I want to restore that backup on SQL Server 2008. Question: Is this possible ?
-2
votes
1answer
51 views

Restored database smaller than the backup file [closed]

The new database created from a restore file is half the size of the backup file I restored from. Why? Original backup settings: Recovery Model: SIMPLE Backup Type: FULL
-2
votes
4answers
6k views

how to restore .bkp file in SQL Server [closed]

I have a .bkp file, how can I restore it to SQL Server? I have SQL Server 2008 and SQL Server 2012. Any idea?
-3
votes
5answers
19k views

Safely deleting a SQL Server log file (.LDF)

I can make sure my app is in a consistent state. I can rollback all the uncompleted transactions if any (just in case) it's ok I can DETACH the database What do I need the log file for after that? ...
-3
votes
1answer
35 views

How Do You Set a SQL Backup to URL Blob Retention Period Greater than 30 Days?

How can a retention period be configured to delete SQL backup blobs older than some custom duration, such as 180 days? The existing command only permits a max of 30 days: use msdb; GO EXEC ...
-3
votes
1answer
144 views

Generate Script Of Database in SQL Server 2008 [closed]

How to Create Script for the Database Objects in SQL server 2008 r2 and restore it in database.
-3
votes
1answer
2k views

SQL Server backup devices autentification by user without access to local computer account or AD [closed]

Please is there way to create procedure to create Backup Device by using different user account, for user account without acces to local computer and not defined in AD too, because description from ...
-3
votes
1answer
899 views

SQL Server 2012 Express Database Backup Script [closed]

Just a quick one. I want to do a full weekly backup of my SQL Server 2012 Express database. I have created a SQL script and batch file to automatically do a full backup of my database each week and ...
-4
votes
1answer
110 views

Oracle database and data has been corrupted. Is there a way to get it back? [closed]

The Oracle database has been corrupted and both the data and backups were lost in the corruption. Is there anything I can do to recover my data? It would be terrible if it were all lost.
-5
votes
0answers
34 views

I need the last backup date, time, and type of backup for all databases [duplicate]

I need a query to find the last backup date, time, and type of backup for every database in a particular SQL Server. How would I get that info?