Viewing 15 posts - 6,241 through 6,255 (of 9,244 total)
Are you initialising the database before setting up log shipping or during?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 19, 2011 at 6:06 pm
Tariq-- (11/19/2011)
hello im looking for an expert who can access remotely and setup for me a database mirroing and troubleshoot it for me,
I can offer a daily rate if that...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 19, 2011 at 5:56 pm
alban_ml (11/19/2011)
problem risolvet ..a login as sa 😀
I would say that's problems just beginning, but that's just me 😉
😀
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 19, 2011 at 4:26 pm
Check out my highly acclaimed 3 part guide for creating a virtual SQL server cluster on this site. It educates the DBA in server, clustering, AD, networking and storage technologies....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 18, 2011 at 1:09 pm
alban_ml (11/18/2011)
how to chek the error state ?
It's in the SQL server log 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 18, 2011 at 12:13 pm
Most of the organisations I have worked in previously have virtualised SQL servers. Obviously not all SQL Servers are ideal virtualisation candidates, this requires some due diligence.
In my opinion virtualisation...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 18, 2011 at 11:07 am
Try adding the node using the setup command line install.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 18, 2011 at 10:42 am
The other option which may be easier for you is to run sp_change_users_login with 'Auto_Fix' and create a matching login for each orphaned database user using a default password. After...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 18, 2011 at 10:38 am
Ok, but DR typically does not encompass your whole estate, it's meant as temporary failover with core services\applications exposed.
Do you really need to LS everything??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 17, 2011 at 7:26 am
See the following link for details of how to implement log shipping via T-SQL, it details all the stored procedures you will need to execute.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 17, 2011 at 6:04 am
NickBalaam (11/11/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 16, 2011 at 2:44 am
Dude Oracle_91
Restore the master backup as a user database, call it oldlogins.
Once database oldlogins has been restored script out username, SID and hashed password for each user in the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 16, 2011 at 2:31 am
Ensure your certificate is for the computers FQDN and not just the computername. I.e. myserver.somedomain.com and not myserver
Ensure you have imported the certificate correctly.
Ensure you have bound the certificate...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 16, 2011 at 2:23 am
Ensure your certificate is for the computers FQDN and not just the computername. I.e. myserver.somedomain.com and not myserver
Ensure you have imported the certificate correctly.
Ensure you have bound the certificate...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 16, 2011 at 2:21 am
winston Smith (11/15/2011)
How do i restore that database backup onto serverB?
You don't need the service master key, A backup of the certificate and its private key are all you need...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 15, 2011 at 9:47 pm
Viewing 15 posts - 6,241 through 6,255 (of 9,244 total)