Database restoring refers to the concept of restore a database from a backup or a copy.
2
votes
1answer
306 views
Ensure correct username when using pg_restore
I have just installed postgres 9.1.6 on a local Ubuntu server. Now I'm trying to restore a database dump from a database on Heroku. The local database is setup like this:
sudo -u postgres psql -c ...
3
votes
0answers
153 views
Why can't I read my transaction log backup file using fn_dump_dblog?
I'm using this blog on sqlskills.com as a guide to practice finding the relevant LSN in a transaction log backup for point in time recovery.
After backing up the transaction log, I attempt to read it ...
0
votes
0answers
279 views
Sybase ASA 9 Central exception on connecting to old database
I have installed sybase ASA 9 i used the sybase central to connect to an old version .db file of ASA version 6, a wizard popup and ask yes or no to unload the database .. for upgrade i click yes ...
0
votes
0answers
156 views
How do I restore a SQL backup, while excluding a specific table?
How do I exclude a specific table during a SQL backup RESTORE operation?
My question is specific to restoring a backup sql file.
I am using Putty and bash server.
