Database restoring refers to the concept of restore a database from a backup or a copy.
2
votes
4answers
2k views
SQL Server: cold backup, shutting down services?
One of our collagues told me that they are doing "cold" backups for SQL Server so that they are shutting down services and then taking a backup somehow. I think this is all wrong! Am I right? I think ...
12
votes
3answers
1k views
Is it possible to quickly create/restore database snapshots with PostgreSQL?
First of all, I'm a developer, not a DBA or sysadmin; please be gentle :)
I'm working on an application workflow where a single user action will trigger complex changes in the database - creating ...
4
votes
1answer
3k views
Restore encrypted database to another server
I'm using a product which runs on SQLServer 2008. Understandably the company supplying it don't offer SQLServer support. When I installed the product I specified a password to encrypt the database. ...
2
votes
2answers
2k views
Postgresql - Recovery using recovery.conf
I am trying to recover a database using recovery.conf file for making point-in-time copy.
On recovery.conf file, I added a recovery target time as below.
recovery_target_time = '2011-06-16 04:10:00 ...
9
votes
2answers
460 views
A Non-DBA Asks: How to Painlessly Copy/Move a SQL Server instance to another Server via Backup/Restore?
We've just got a new server so I need to copy the existing SQL Server 2008 instance over from the old db box.
I normally do this by copying .mdf and log files over and attaching them but I'm not able ...
4
votes
5answers
5k views
User Permissions Messed Up following a Backup -> Restore Operation
I had to move several SQL Server 2008 databases to our new db server so I backed them all up (to .bak files), copied these files over to the new box and restored them (all done using SQL Management ...
4
votes
1answer
714 views
SQL 2005 Full Recovery Mode Point in Time Restore w/out Backup
We have a database that is in full recovery mode. The database is not in production yet so does not have a backup plan in place and is thus not being backed up. In other words, there is no existing ...
5
votes
3answers
7k views
How to restore multiple backups
I'm using ExpressMaint and Windows Scheduled Tasks to create weekly full and daily differential backups of some MS SQL Server 2008 R2 Express databases
Weekly fulls
expressmaint -S ...
1
vote
5answers
3k views
How to restore database using old full backup and current log file
What is happened? My client has lost the hard disk. He has to restore database.
He has the full backup of database 15 days old.
He has ldf (log) file of this database.
He has NOT mdf file (it was ...
