Viewing 15 posts - 7,141 through 7,155 (of 9,241 total)
RAID10 requires an even number of drives.
The best solution with 12 drives available would possibly be
OS RAID1 (2...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 14, 2011 at 8:56 am
G.Sudhagar (4/13/2011)
1)first step will delete old backup file based on ur need (days).
you would be well advised to delete files AFTER a successful backup for obvious reasons
TheHose
I use a VB...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 14, 2011 at 8:42 am
SQLIO stress testing will primarily affect the SAN so no you wouldn't run it on production. These sorts of tests should be carried out before the Server and SAN are...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 14, 2011 at 8:36 am
Andrew Clark-151434 (4/13/2011)
Thanks for any replies, I have found the problem. Our AD replication wasn't working so any permission changes on AD accounts weren't replicating for about 13 hours. Once...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 13, 2011 at 2:19 pm
no need to take a FULL backup here to restart the log chain, a DIFFERENTIAL will suffice and allow subsequent transaction log backups
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 12, 2011 at 2:12 am
why are you bothering to offload this through SQL Server? Send mail directly from the app straight to the SMTP server using System.Net.Mail class, there is a MailMessage() object there...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 12, 2011 at 2:05 am
Hi
execute the following against MSDB and post the results
select object_name(object_id),
(used_page_count * 8) / 1024 as TableSizeInMBs,
row_count
from sys.dm_db_partition_stats
order by row_count desc
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 12, 2011 at 1:54 am
SQLJocky (4/8/2011)
has now moved to Avamar (disk based backup solution) for our backup and partial DR strategy.
i'm guessing this interfaces with VCB and snapshots the VM's virtual disks!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 11, 2011 at 2:05 pm
the stored procedure
sp_delete_backuphistory
is used to trim the history tables. You can find details of this in Books Online
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 11, 2011 at 11:40 am
forsqlserver (4/11/2011)
[highlight=#ffff11]Windows detected your registry file is still in use...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 11, 2011 at 11:32 am
clustering requires AD and AD is dependant upon DNS, they are all tied very neatly together.
Just out of interest, why do you ask if you can implement clustering without these...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 11, 2011 at 11:31 am
Further to what Jeffrey has said, you get the option during the SQL Server 2008 install to use service account SID based security or traditional global\local group security. Obviously service...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 11, 2011 at 11:28 am
Abrar Ahmad_ (4/11/2011)
[font="Verdana"]Some sign of relief @http://scottf.wordpress.com/2007/02/09/sql-server-on-vmware-server/
[/font]
That link covers VMWare Server which although very good is not a patch on it's big brother ESX server. The two are vastly different...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 11, 2011 at 11:14 am
kstjacques (4/11/2011)
We have two virtual machines running Windows Server 2008 R2 (each virtual sitting on a separate ESX...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 11, 2011 at 11:08 am
annasql (4/10/2011)
If so, what should we do?
Quite often the database properties will be become inaccessible so use the stored procedure
sp_ChangeDBOwner to change the ownership of the database
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 10, 2011 at 4:52 am
Viewing 15 posts - 7,141 through 7,155 (of 9,241 total)