Viewing 15 posts - 8,761 through 8,775 (of 9,248 total)
i have books from Wrox which are fantastic
Professional SQL 2005 programming
Professional SQL2005 performance tuning
I recommend these. They go into a lot of detail about the database engine (datafiles, logfiles,...
November 17, 2008 at 10:28 am
it could be the backup is larger than the free space available!!
November 17, 2008 at 10:12 am
database mirroring provides a warm standy copy of the database.
Log shipping works differently, log files are shipped to a remote database and applied. The database has 1 of 2 states,...
November 17, 2008 at 10:10 am
samuel.tillman (11/10/2008)
6x72GB HHDs. What I have been asked to do specifically is setup the raid configuration and the backup scheme for the Databases and Transaction Logs.
RAID 5 is ideal for...
November 16, 2008 at 6:24 am
Marios Philippopoulos (11/16/2008)
I have heard that Microsoft does not officially support virtualized SQL Server installations.
untrue as far as i am concerned. I had a call open recently with MS...
November 16, 2008 at 6:15 am
Ninja's_RGR'us (11/15/2008)
Wow, amazing stuff, you guys should write an article about this!!!
i have been tempted for some time 😉
November 15, 2008 at 2:33 pm
why not just run the scripts through a sql job, no need to use SSIS
November 15, 2008 at 12:17 pm
although you ran a log backup there could be an active transaction occupying the end of the log file
run
dbcc opentran to check for open transactions
then
dbcc loginfo
a status of 2...
November 15, 2008 at 12:15 pm
Ninja's_RGR'us (11/15/2008)
Any recommended products from your experience?
personally you cant beat VMWare VI3. There are a number of players in this arena now, but remember VMWare have a 10 year +...
November 15, 2008 at 12:04 pm
you need to research and decide on a virtualisation product and storage method first then build from there as the hypervisor and storage mediums form the foundation of the systems
November 15, 2008 at 4:33 am
Andrew Peterson (11/5/2008)
The simple approach is to drop and restore the logins with the sid as part of the create login command.
why not just script off the logins from the...
November 14, 2008 at 6:24 am
definitely shutdown SQL server instances.
make sure you have a full backup of the data files before defrag.
Rebuild all your indexes after the defrag
November 14, 2008 at 3:28 am
Hi
the first question i need to ask you is
what platform are you using for virtualisation?
We currently use VMWare VI3 comprising of 10 ESX 3.5 hosts
Dont get ESX server confused...
November 14, 2008 at 3:17 am
stacked IP addresses are another way to have SQL listen on multiple IP's and ports
November 12, 2008 at 3:43 pm
Steve Jones - Editor (11/12/2008)
You can't, but if it's a daily load, why do you care? The space will get reused tomorrow.
that's a very valid point
November 12, 2008 at 3:38 pm
Viewing 15 posts - 8,761 through 8,775 (of 9,248 total)