Viewing 15 posts - 76 through 90 (of 115 total)
So, what are you asking about here?
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
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...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
October 15, 2012 at 12:20 am
More often than not, the best thing to do is to not shrink at all though.
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
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....
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
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...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
March 18, 2011 at 1:53 pm
homebrew01 (3/18/2011)
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
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...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
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...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
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...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
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...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
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...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
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...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
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...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
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...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
July 21, 2009 at 2:12 am
Cathy DePaolo (7/20/2009)
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
July 21, 2009 at 1:17 am
Viewing 15 posts - 76 through 90 (of 115 total)