Reputation
203
Top tag
Next privilege 250 Rep.
View close votes
Badges
1 5
Newest
 Yearling
Impact
~6k people reached

  • 0 posts edited
  • 0 helpful flags
  • 1 vote cast
Jul
1
comment Hyper V replication - vs - sql replication solutions
Hi, believe that the internal works are quite similar between the two options, ie both will need to be based on application-aware use of VSS/snapshots in order to safely replicate the state of the database. Nonetheless, they are quite different in approach (database vs VM)
Jun
30
awarded  Yearling
Jun
30
comment Hyper V replication - vs - sql replication solutions
"EnableWriteOrderPreservationAcrossDisks" - if separate VHDs are used for logs and data, write order need to be identical at replica to avoid database integrity issues - for background/explanation, see simple-talk.com/sql/database-administration/…
Jun
29
revised Hyper V replication - vs - sql replication solutions
added 26 characters in body
Jun
29
revised Hyper V replication - vs - sql replication solutions
added 26 characters in body
Jun
29
asked Hyper V replication - vs - sql replication solutions
Feb
17
awarded  Scholar
Feb
17
awarded  Supporter
Feb
17
accepted Using “Generate Scripts” with EMERGENCY/SINGLE USER mode
Feb
17
comment Using “Generate Scripts” with EMERGENCY/SINGLE USER mode
In the end, I created a new database on the same instance, used the "Script as.." to get the "CREATE TABLE" script (excl data), and then copied the data over as suggested by you. From the healthy database I could easily get the full insert query using "Generate scripts". +Accepted for the workaround
Feb
16
awarded  Student
Feb
16
comment Using “Generate Scripts” with EMERGENCY/SINGLE USER mode
I've tried that option, but it seems it does not include data. What I am using is "tasks"->"generate scripts" on the database itself. It has an option to include data. BTW, I am able to do SELECTs on the data and can of course manually create insert statements from the (tabular) data I get.
Feb
16
comment Using “Generate Scripts” with EMERGENCY/SINGLE USER mode
I tried KILLing the connection right before the generation step in the script wizard, but I got the same error. Looks like it creates another connection.
Feb
16
asked Using “Generate Scripts” with EMERGENCY/SINGLE USER mode
May
6
comment Entity Relationship Model for linked tables
Hi, credits for pointing out my assumptions, which might not be valid. Adding the translator as author-per-country would complicate things. One solution could be to add the author link table between Book-Country and Author tables - to get a list of authors for every book-country combination. Another to use the link table as suggested by @Aufwind with Author-Book-Country, but with the Country ID taken to mean something like "if NULL valid for all countries", if set only for this country (i.e. translator(s))
May
5
answered Entity Relationship Model for linked tables
May
5
answered How do you restore a particular table in MySQL?
May
4
awarded  Editor
May
4
revised How do I make MySQL auto increment in random order?
added 5 characters in body
May
2
awarded  Teacher