Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
5
Newest
 Critic
Impact
~55 people reached

  • 0 posts edited
  • 0 helpful flags
  • 7 votes cast
Nov
24
comment How to setup SQL Server 2014 replication for a demo site
Agree with mar_s but be advised, people in dba will expect you to try to understand how replication works first, and make concrete questions. Can you even describe what type of replication you want? Master/slave, multi-master?
Nov
24
comment How to setup SQL Server 2014 replication for a demo site
Instead of trying to find something that matches your exact scenario, try to understand how replication works. Books Online and Technet are very good resources and they do explain how to set up different scenarios. You'll never find a solution though if you are trying to find something that matches your terms and assumptions. Most likely, you've already found the relevant article but didn't recognize it
Oct
8
comment Check data is the same after restore SQL
@EvaldasBuinauskas agree but the question isn't clear, it will be closed rather quickly
Oct
8
comment Check data is the same after restore SQL
First, it's SQL Server 2008 R2. Second, the database will definitely not be the same as it was before the restore, unless nothing was written to it since the last backup. Are you trying to ask something else?
Aug
5
comment When backup a database
Backup and recovery plans have nothing at all to do with database size. They are determined by how you want to recover your data when a disk explodes and how hard it is to recreate the data instead of restore it. Reporting data that can be rebuilt from sources can be backed up once a day using a full backup. Transaction data that must be recovered up to the last 10 minutes also require log backups every 10 minutes.
Jun
16
awarded  Critic
Jan
23
comment Update SQL Server .net version
.NET 4.5 is a binary replacement for 4.0 which means it replaces the actual 4.0 binaries. There is no v4.5 folder.
Jan
21
awarded  Organizer
Jan
21
revised Recover data in a SQL Server table without backups
Added more specific tags
Jan
21
suggested approved edit on Recover data in a SQL Server table without backups
Jan
21
comment Recover data in a SQL Server table without backups
You need to specify what happened. In your original question in SO you mentioned that data was deleted by a script. What backup mode are you using (full, simple)? You may be able to perform a point-in-time restore if you are using full logging. Take a database snapshot before you attempt anything so you can revert is something goes wrong
Oct
15
awarded  Supporter
Oct
7
comment Unable to copy a DB from SQL Server 2000 to SQL Server 2012 using copy wizard
The Copy Database Wizard in SQL Server 2012 doesn't support databases earlier than 2005
Dec
15
awarded  Teacher
Dec
14
answered Is it possible to CREATE EVENT to another server?
Dec
14
comment Is it possible to CREATE EVENT to another server?
It's triggers that require an open connection, not replication.
Jan
16
awarded  Autobiographer