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

  • 0 posts edited
  • 0 helpful flags
  • 4 votes cast
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.
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
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
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
14
comment Is it possible to CREATE EVENT to another server?
It's triggers that require an open connection, not replication.