Viewing 15 posts - 7,156 through 7,170 (of 9,253 total)
no need to take a FULL backup here to restart the log chain, a DIFFERENTIAL will suffice and allow subsequent transaction log backups
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...
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
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!
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
April 11, 2011 at 11:40 am
forsqlserver (4/11/2011)
[highlight=#ffff11]Windows detected your registry file is still in use...
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...
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...
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...
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...
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
April 10, 2011 at 4:52 am
homebrew01 (4/8/2011)
2) Take one-time full backup now to re-establish log chain
no need for a full, a differential will do the trick
April 9, 2011 at 6:02 pm
dont forget to enclose database names such as that above with these []
use the QUOTENAME() function
April 9, 2011 at 5:56 pm
Take source database offline
copy disk files to target server
re attach at target server
April 9, 2011 at 5:53 pm
Marios Philippopoulos (4/8/2011)
The logship.exe file, used for transaction-log backups, did not get deployed properly: it...
April 8, 2011 at 3:17 pm
Viewing 15 posts - 7,156 through 7,170 (of 9,253 total)