Skip to main content

New answers tagged

1 vote
Accepted

Adding a db to an AG - full backup required prerequisite, can I use that backup for the seeding?

Could I have used my manual full+log to prep the secondaries? Yes, especially since they were already on a share. You can manually prep the database in an AG by restoring it and leaving it in a ...
Sean Gallardy's user avatar
1 vote

Why can't I restore my SQL-Server database?

I think this query here from my friend John can help you: /*-------------------------------------------------------------------------*\ This query will generate the proper restore chain for all ...
Marcello Miorelli's user avatar
0 votes

How can I replicate transactions one by one in mysql?

You can use mysqlbinlog to examine the binary logs, to get the exact position where the DROP TABLE A event occurs. Here's an example from my local instance, where I ran a drop table event. $ ...
Bill Karwin's user avatar
3 votes
Accepted

Why can't I restore my SQL-Server database?

All that the GUI does is to create a bunch of T-SQL commands for you. The restore dialog, in particular is a very difficult beast to understand. When I teach, I can explain backup and restore ...
Tibor Karaszi's user avatar
0 votes

Website Content Not Displaying Correctly in Vietnamese After Restoring Database from Backup

"restored the website using the backup" -- Could we see a little more of the backup -- namely where some Vietnamese text can be seen. I worry that the backup may have been messed up. Also, ...
Rick James's user avatar
  • 79.4k

Top 50 recent answers are included