Viewing 15 posts - 4,516 through 4,530 (of 9,253 total)
sql-lover (12/3/2012)
I'm having a hard time to convince IT team that we don't need so many NICs in a dedicated SQL cluster. Besides SAN, I usually use two NICs only,...
December 3, 2012 at 1:39 pm
It's now WSFC and it is indeed part of the Windows 2008 server Enterprise and Datacenter editions.
December 3, 2012 at 1:36 pm
Ratheesh.K.Nair (12/3/2012)
Perry how can we achieve that? If did ,it is having high chance for corrupting the backup right.
Not at all, I've never had an issue with the backup converter
December 3, 2012 at 11:45 am
HildaJ (12/3/2012)
I need to restored the master db file from one of my red gate backup files. I'd like to know the required steps to do this.thank you.
The easiest...
December 3, 2012 at 8:36 am
ravi@sql (12/3/2012)
ya maxsize is given for autogrowth
What are the size details for the log currently?
Do you have any long running transactions?
December 3, 2012 at 6:03 am
sql_Reporter (12/1/2012)
Hey probably a very common question but can you Replication between SQL 08 r2 enterprise & standard editions ?Thanks
December 3, 2012 at 6:01 am
ravi@sql (12/3/2012)
recovery_model_desclog_reuse_wait_descSIMPLE NOTHING
What size is...
December 3, 2012 at 5:50 am
if your database is using the full or bulk logged recovery model take a transaction log backup using the following
BACKUP LOG [MYDB] TO DISK = 'some drive\some path\mydb.trn'
December 3, 2012 at 5:48 am
shohelr2003 (12/3/2012)
Now I want to change my operating mode to High Performance (Asynchronous) but getting all options disabled.
How can I...
December 3, 2012 at 5:12 am
You can just obtain the max id value after toe deletion by using
select max(col_id) from table_name
Then use this to determine the reseed value.
December 2, 2012 at 11:51 pm
cracked it have you? 😉
November 30, 2012 at 1:43 pm
You must ensure that while no cluster is formed that the 2 nodes do not try to access the disks at once otherwise corruption occurs. Simply hold off exposing the...
November 30, 2012 at 12:52 pm
sdpages (11/30/2012)
Will these trans log backup be used with my Weekly Full and Daily Diff backups for a Restore ?Please suggest.
thanks.
yes, the log backups taken by the LS...
November 30, 2012 at 12:50 pm
SQL SERVER ROOKIE (11/30/2012)
Thank you guys,And how to look for tables in a DB lets say any table with the word "SHIPPING"Regards
SM
This
selectobject_name(object_id) AS TableName
from sys.columns
where object_name(object_id) like '%table name string%'
group...
November 30, 2012 at 12:46 pm
Your post isn't clear but here goes
if you have a log shipping plan in action, ensure that the only transaction log backups are taken by the log shipping backup job...
November 30, 2012 at 11:05 am
Viewing 15 posts - 4,516 through 4,530 (of 9,253 total)