My question is about difference between "backup &amp; restore" and "detach &amp; attach" in SQL Server.    What is the meaningful difference between these two methods?
124120
I have one database which contains the most recent data, and I want to replicate the database content into some other servers. Due to non-technical reasons, I can not directly use replicate function or sync function to sync to other SQL Server instances.  Now, I have two solutions, and I want to learn the pros and cons for each solution. Thanks!  Solution 1: detach the source database which contains the most recent data, then copy to the destination servers which need the most recent data, and attach database at the destination servers;  Solution 2: make a full backup of source server for the whole database, then copy data to destination servers and take a full recovery at the destination server side.  thanks in advance, George
5162
Using SQL Server - which is the fastest or best practice method to use for date retrieval? Is there a difference?
83449
We have been using Notes and Attachment to store files related to the record. I also read about Files in salesforce.   How are Files different from Attachment? Are there any limitations or benefits of using Files instead of Attachments?  Are Files available for all editions of Salesforce?  Is it possible to link Files to particular records so they are visible as related list? I tried looking into the content version  but cant seem to find anything to relate to a record
86079
I recall there is a difference between some methods/properties called directly on the  class, and the identically named methods/properties on the  property. (Might have been the RowCount/Count property for which I read this.) The difference is one of them disregards , and the other respects/uses it.  In this particular case I'm wondering about the difference between  and . I can imagine one of them actually removes all rows, and the other one just marks them as deleted.  So my question is, is there a difference between the two Clear methods, and if so what is the difference?  (Oh, this is for .NET 1.1 btw, in case the semantics changed from one version to another.)
12433
What exactly does the restore argument "With Replace" do? I'm looking at needing to restore a database back to a beginning point on a regular basis, and I've been trying to figure out if there are any disadvantages to using Restore With Replace versus Dropping/Deleting the database entirely and restoring it.  Will "With Replace" wipe the log files and reset whatever bits might be left in system databases as well? It seems that it would be much quicker, as I don't have to wait for the database to finish dropping (the database in question is around 2TB). I've already checked the TechNet article on the Restore arguments, it doesn't go into this specific question.
32122
No, this is not a , nor is it a solicitation on  to backup or  and only a little bit about Where to backup and When to do it.  This is basically a strategy question: what, where and when all together. "How" is not really relevant: there are tons of back-up programs out there and they all do the same basic thing: make copies of data.  But the real question is: are these back-up programs making copies of the data important to you?  How should you install&amp;run Ubuntu while safeguarding your data?  There is no "one size fits all" when it comes to computers, Ubuntu versions or a backup strategy, therefore I've split this up into 5 basic user types with each their own answer:       (or you're running in UEFI mode!)   And as the above does not fit everyone, one for the impatient:   !    So click one of the above links and go to your user type!  P.S. If you're running a server farm and you've read this question so far, I'm sorry: this is about a single PC, not a network, nor a server farm.
60605
What is difference between Server.Transfer and Response.Redirect?   What are advantages and disadvantages of each? When is one appropriate over the other? When is one not appropriate?
36917
Why did MS originally make the decision to maintain these two separate core libs? Maybe they had some scalability issue in mind, but nowadays I never see an application, of any type, that doesn't need both. Does anyone have any inside information on this? It's not really important, but been on my mind for years.  PS. I know what's in the two libs, I know the difference - I'm a big fan of  :) Just wondering what practical use the separation of the two has.
94661
I am migrating SQL Server DBs to a new instance.  I have been told that it is possible to dynamically build a RESTORE script from available backups in the system catalog.  Does anyone know of a sample script to do this?  Thanks!
50366
What are the recommendations of software products for creating automated backups of SQL Server 2008 databases?  The backup should happen without taking the database offline/detatching.
81860
From a (very long, but definitely worth to read) :  When you delete a file in your OS, there is no reaction from either a hard drive or SSD. It isn’t until you overwrite the sector (on a hard drive) or page (on a SSD) that you actually lose the data. File recovery programs use this property to their advantage and that’s how they help you recover deleted files. The key distinction between HDDs and SSDs however is what happens when you overwrite a file. While a HDD can simply write the new data to the same sector, a SSD will allocate a new (or previously used) page for the overwritten data. The page that contains the now invalid data will simply be marked as invalid and at some point it’ll get erased.  So, what would be the best way to securely erase files stored on a SSD? Overwriting with random data as we are used to from hard disks (e.g. using the &quot;shred&quot; utility) won't work unless you overwrite the WHOLE drive...
63057
When should I use the full recovery model and when should I use the simple recovery model for databases?  I always used the full recovery model because it is the default, but today i encountered this error:     Microsoft OLE DB Provider for SQL Server (0x80040E14) The transaction   log for database 'DATABASE NAME' is full. To find out why space in the   log cannot be reused, see the log_reuse_wait_desc column in   sys.databases   The specific database is actually one of the smallest and most inactive databases on my server, so I have no idea how the log can be full on this database, and not the others.  To shrink the log and making the database accessable again, I changed the recovery model from FULL to SIMPLE and shrinked the logical file log, with the following command  alter database myDbName SET recovery simple go dbcc shrinkfile('LOG FILE LOGICAL NAME', 100) go   It helped, but now I need to understand WHY it helped, HOW this situation started and HOW to prevent this in the future?  EDIT:  Every night at 1 o'clock, we are doing a scripted backup of every database on the server. This is being done by a 31 line script where the most important part is  set @Filename = 'D:\backup\' + convert(varchar, getDate(), 112) + ' - ' + @DBName + '.bak' set @Description = 'Full backup of database ' + @Filename BACKUP DATABASE @DBName TO DISK = @Filename WITH INIT , NOUNLOAD , NAME = @Description, NOSKIP , STATS = 10, NOFORMAT   Is the new recovery model and databaseshrink going to be a conflict with this script?  We are not doing any other kind of backup of the databases, and therefore not the transaction logs, should we?
12048
What are good methodologies for creating sprocs that reduce the pain of debugging? And what tools are out there for debugging stored procedures?  Perhaps most importantly, what are indications to look out for that errors are happening in a sproc and not in the code? I hope I'm not all over the board too terribly bad here. Votes for answers to any of the above. Thanks.  For what it's worth, I work in a .NET environment, SQL servers.
7822
I want to do one way synchronization.  I am having Folder A on my computer which is constantly updated with content. Another Folder B is used for backup purpose which is on external HDD.  Now what I expect is that whatever extra which is present in folder A should go to folder B. However something which is present in B and NOT in A ""shall NOT be copied to A"".  In a nutshell, the backup folder may copy everything from the source folder, however nothing should be copied form backup folder to the source.
86890
I had a MSSQL (MSSQL 2008 R2) cluster that failed in a way that I couldn't bring it back up (long story, servers ended up in BSOD loops, I'm blaming Broadcom and myself).   I've SQL backups, and even better, I've got the detached MDF and LDF files as they were on the SAN before everything went wrong. I've now got the task of restoring these back to a newly built server.   The databases themselves, logins and SSIS packages aren't a problem, as I've got all these. The thing that's bothering me is the SQL Agent jobs that were defined on the previous server. I'm dimly aware that these are stored in MSDB somewhere, but what steps should I go through to retreive these from the MDF/LDF files I've already got and load them on the new server?  I'm not going to be restoring the modal, msdb, master and temp databases on the new server, so should I be looking to attach the old files under different names and pull job definitions out of them, or is there some other (better) way?
41779
I m trying to understand where we use following Database.Methods. I know if we want to insert a record to an object we use DML Statement. What i want to know is why/where we use Database. methods. It might be silly question. Database.saveResults Database.insert Database.query Database.Query Database.error   really appreciate the inputs. Thanks a ton in advance.
94072
For my new server, I want to setup a proper backup solution. I've found a great setup that will do twice-daily incremental backups via Dropbox. I plan on backing up my various databases, the webroot directory, the /etc directory/repository, and /var/log.   What else do I need to know to do a proper backup, and what is the standard setup here to ensure you can quickly restore from a backup in the case of a system failure?  I'm thinking of using Puppet, as it describes how the system should be. My restore procedure would look like this:   Install Puppet Run my puppet config Restore my backups from Dropbox (Should I create a script to do this? Probably)   This should also let me create a clone of my production server for use in dev environments, correct? Am I missing anything of importance?