Viewing 15 posts - 7,141 through 7,155 (of 9,244 total)
Sven Worm (4/17/2011)
This documentation seems to be offline. Does anyone can get it online again ?Thanks
Sven
I have fixed the link for you, right click and download it to hard drive...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 17, 2011 at 9:41 am
Sorry i do apologise, i forgot the WHERE clause :blush:
Please execute this against MSDB and post results
select object_name(object_id),
(used_page_count * 8) / 1024 as TableSizeInMBs,
row_count
from sys.dm_db_partition_stats
where index_id in (0,1)
order...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 15, 2011 at 9:47 am
samsql (4/15/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 15, 2011 at 8:20 am
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
Viewing 15 posts - 7,141 through 7,155 (of 9,244 total)