meta user
network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 1 year, 9 months |
| seen | Aug 6 '12 at 2:41 | |
| stats | profile views | 3 |
|
Nov 15 |
awarded | Announcer |
|
Nov 5 |
awarded | Popular Question |
|
Jul 26 |
revised |
Why not use SQL_Latin1_General_CI_AS for a global system? another grammar fix |
|
Jul 25 |
revised |
Why not use SQL_Latin1_General_CI_AS for a global system? Added tag to specify that I'm using Microsoft SQL Server 2008 R2, and also corrected collation names (again) |
|
Jul 25 |
revised |
Why not use SQL_Latin1_General_CI_AS for a global system? I got the collation name wrong, so I fixed it. |
|
Jul 25 |
revised |
Why not use SQL_Latin1_General_CI_AS for a global system? added a question I forgot to write |
|
Jul 25 |
asked | Why not use SQL_Latin1_General_CI_AS for a global system? |
|
Nov 8 |
awarded | Scholar |
|
Nov 8 |
accepted | How to Setup SQL Server 2008 R2 Mirror |
|
Nov 8 |
answered | How to Setup SQL Server 2008 R2 Mirror |
|
Nov 1 |
comment |
How to Setup SQL Server 2008 R2 Mirror They are both using 5022. The firewall rules are also set properly since I can telnet 5022 both ways. The 2 computers are in different domains but I am using SQL authentication so it shouldn't matter, should it? I am taking a full backup and full log backup to restore, both with NORECOVERY. Anything else? |
|
Nov 1 |
comment |
How to Setup SQL Server 2008 R2 Mirror I used NORECOVERY but it's not accepting further restores, since I can't restore the log. So why would that be? |
|
Oct 14 |
awarded | Editor |
|
Oct 14 |
comment |
How to Setup SQL Server 2008 R2 Mirror Yes, the mirror can connect to the principal with telnet. I can't restore the log backup, apparently because I used the WITH NORECOVERY clause: "The selected database, MyDB, cannot be restored in its current state. (SqlManagerUI)" |
|
Oct 14 |
revised |
How to Setup SQL Server 2008 R2 Mirror added info requested by Mark Storey-Smith |
|
Oct 14 |
awarded | Student |
|
Oct 14 |
asked | How to Setup SQL Server 2008 R2 Mirror |
|
Aug 29 |
comment |
Running query against SQL Server with FreeTDS's bsqldb returns blank output bsqldb doesn't seem to like your SQL: "Msg 102, Level 15, State 1 Server 'DEV-DB', Line 1 Incorrect syntax near 'ISNULL'. bsqldb: Msg 20018, Level 5 General SQL Server error: Check messages from the SQL Server. bsqldb:191: dbsqlok() failed" |
|
Aug 26 |
asked | Running query against SQL Server with FreeTDS's bsqldb returns blank output |
