Viewing 15 posts - 4,516 through 4,530 (of 9,244 total)
sql_Reporter (12/1/2012)
Hey probably a very common question but can you Replication between SQL 08 r2 enterprise & standard editions ?Thanks
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 3, 2012 at 6:01 am
ravi@sql (12/3/2012)
recovery_model_desclog_reuse_wait_descSIMPLE NOTHING
What size is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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'
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 2, 2012 at 11:51 pm
cracked it have you? 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 30, 2012 at 11:05 am
if using local system you need to allow the machine account access to the network share
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 30, 2012 at 11:01 am
What are the specs for each VM?
You have to bear in mind that the host will have an overhead for its OS and the VMWare Workstation Hypervisor before you even...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 30, 2012 at 10:59 am
you'll typically see this when there aren't enough resources on the host machine to service all the VMs. Can you supply the full spec of your VMWare host?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 30, 2012 at 9:19 am
This is fairly straightforward
selectobject_name(object_id) AS TableName
, name AS ColumnName
from sys.columns
where name like '%columnname string%'
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 30, 2012 at 6:06 am
abhishekkulkarni1284 (11/29/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 30, 2012 at 5:58 am
Viewing 15 posts - 4,516 through 4,530 (of 9,244 total)