Viewing 15 posts - 76 through 90 (of 114 total)
So, what are you asking about here?
October 15, 2012 at 2:45 am
Sounds fairly straight forward to me.
Basically, each SQL Server instance is set up as a separate installation and should not interfere with other instances as long as you have enough...
October 15, 2012 at 12:20 am
More often than not, the best thing to do is to not shrink at all though.
March 22, 2011 at 5:58 am
Yes, if the full backup never ran at all so that the full backup before that is still the most recent full backup, you can still use all your diffs....
March 19, 2011 at 1:32 am
A restore between different versions will only work from a lower to a higher version, not the other way around because the system tables of a SQL Server 2008 database...
March 18, 2011 at 1:53 pm
homebrew01 (3/18/2011)
March 18, 2011 at 10:53 am
Basically, if you want to do log backups at all, you'll want to do them fairly often!
Doing so only once a day is both a lot riskier and far worse...
March 18, 2011 at 10:46 am
rmechaber (3/18/2011)
In other words: Making an ad-hoc full backup of a database (unless made with the "copy only" option introduced in SQL server 2008) ...
Minor amendment: Copy-only backups http://msdn.microsoft.com/en-us/library/ms191495%28v=SQL.90%29.aspx
were implemented...
March 18, 2011 at 10:28 am
First of all, if you're upgrading SQL Server 2005 now, I would go for SP4, not SP3.
You should make a full backup of all databases prior to upgrading and a...
March 17, 2011 at 6:09 am
Shrinking won't break anything, it just releases free space in the log file itself. The best way to do this is to make a log backup immediately before shrinking because...
March 17, 2011 at 5:55 am
Basically, it works like this:
A full backup is just that - a full backup.
It will completely restore the database to its state at the time the full backup was...
March 17, 2011 at 5:33 am
You can't include any system objects because 2005 system objects are not supported by 2000. If you allow 2000 to create its own system objects and copy only the user...
July 22, 2009 at 2:56 am
Each SQL Server instance is considered a separate SQL Server installation, and so yes, it will have it's own separate directory structure. Looks like others have already pretty much covered...
July 22, 2009 at 2:43 am
I generally reorganize / rebuild indexes once a week, but I still don't shrink the log and I don't see any good reasons to do so. After all, we already...
July 21, 2009 at 2:12 am
Cathy DePaolo (7/20/2009)
July 21, 2009 at 1:17 am
Viewing 15 posts - 76 through 90 (of 114 total)