Viewing 15 posts - 3,001 through 3,015 (of 9,244 total)
jamessdba (9/2/2014)
1) If principle server down what willl happen to Mirror DB & Transactions
Depends, if you have a witness and the session loses quorum with the mirror the principal will...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 2, 2014 at 4:16 am
Chowdary's (9/2/2014)
when i was configured the logshipping the server IP address was 192.168.0.xxx ,And I configured Logshipping successfully.
Now the ip Address was changed to 192.168.0.yyy for some security purpose...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 2, 2014 at 4:07 am
Tail log is taken using the following (assuming the db is online and undamaged)
Backup log db1
to disk='c:\myfolder\Taillog.trn' with norecovery
If the database is damaged you could use
Backup log db1
to disk='c:\myfolder\Taillog.trn' with...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 2, 2014 at 3:59 am
the actual share will be \\W2K8SQLBACKUP\SQLBackup and not \\W2K8SQLBACKUP\SQLBackup\wslogdb70_28.
Check the permissions at the share level and also the NTFS permissions too on the subfolder wslogdb70_28.
Check the account that sql agent...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 2, 2014 at 3:48 am
check the logs for storage related errors, you may well find there related errors being reported
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 2, 2014 at 3:43 am
mr_belpitt (9/2/2014)
sp_change_users_login 'update_one', 'the_username', 'the_username'Substitute "the_username" for your actual username.
Don't take this for granted, the server login and database user won't necessarily have matching names.
It's possible to have a login...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 2, 2014 at 3:10 am
krishnaprasad_mt (8/31/2014)
Please help me with a SQL query to understand the names of all the available tables , number of records in these tables and size of...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 1, 2014 at 9:32 am
Ratheesh.K.Nair (8/29/2014)
Hi Experts,How can we check whether all users in Always On primary is there in Secondary with all the access?
TIA
Not entirely sure what it is you mean, but if...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 29, 2014 at 5:41 am
Pablo Campanini-336244 (8/28/2014)
1.- Can I set up Always-On in both servers?. and have 1 or 2 databases with Always-on?
No, requires a Windows Server Failover Cluster
Pablo Campanini-336244 (8/28/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 29, 2014 at 2:22 am
PearlJammer1 (8/28/2014)
We use replication...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 28, 2014 at 8:54 am
mqbk (8/28/2014)
Is there a way to be able to do this with writes? Can I have in essences 2 masters that some how reconcile with each other?
No, that is not...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 28, 2014 at 8:52 am
Wheres the information for the second availability group?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 27, 2014 at 12:32 pm
i see no readonly routing urls, no secondary connections allowed and no listener details in the output from the 2nd query!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 27, 2014 at 10:13 am
Please send me the outputs of these queries
SET CONCAT_NULL_YIELDS_NULL OFF
SELECT'AlwaysOn Group ' + QUOTENAME(AG.NAME) + ' has the following members;'
FROM SYS.availability_groups AG
UNION
SELECT'Replica ''' + ar.replica_server_name + ''' identified...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 27, 2014 at 8:29 am
enriquemallon (8/27/2014)
You get "Access is denied.". So, it seems like the service account for SQL Server doesn't have permissions on where you try to produce the backup file.
The error is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 27, 2014 at 8:18 am
Viewing 15 posts - 3,001 through 3,015 (of 9,244 total)