Viewing 15 posts - 2,986 through 3,000 (of 9,244 total)
do you plan to use separate NICs or one NIC?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 4, 2014 at 5:32 am
bpowers (9/3/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 4, 2014 at 5:29 am
if running under local system you shouldnt need to do anything
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 4, 2014 at 5:26 am
Whats your environment like?
For example, If it takes 2 days just to rack the servers and connect the storage this would need to be factored in.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 3, 2014 at 11:03 am
Yes you can add extra IP addresses for SQL server to listen on, you either stack them on the same NIC or have separate NICs
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 3, 2014 at 10:57 am
You'll need to create a new SPN if you change the computername and the svc account does not have permission to do it automatically.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 3, 2014 at 10:50 am
Chowdary's (9/3/2014)
thank you for reply,Can you pls tell me the TUF file path,where it will be created when we configure the log shipping.....
Regards
Chowdary...
To be honest i can't remember, you could...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 3, 2014 at 9:06 am
what is your question??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 3, 2014 at 5:44 am
cstrati (9/2/2014)
The SQLServer and SQLAgent login are both under login "local system"
This violates all Windows and SQL server security Best Practice.
cstrati (9/2/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 2, 2014 at 11:58 pm
that's not surprising
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 2, 2014 at 10:31 am
GilaMonster (9/2/2014)
Perry Whittle (9/2/2014)
jamessdba (9/2/2014)
3) In BulkLogged can we take Point in time recovey?You don't, they're not supported
You can. It depends on whether or not there's been a minimally logged...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 2, 2014 at 10:14 am
have you executed all the queires i supplied above, it looks like you havent ran
exec sp_delete_log_shipping_primary_database
@database = 'database'
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 2, 2014 at 7:24 am
jacksonandrew321 (9/2/2014)
Hi FolksWhere would i find my particular database Error log file, Event log file and Trace file etc?
Thanks
SQL Server log you will find in the dump directory for sql...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 2, 2014 at 5:09 am
mr_belpitt (9/2/2014)
Perry Whittle (9/2/2014)
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 2, 2014 at 4:30 am
Generally you'd remove the secondary information first, especially if you plan to re use the primary config 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 2, 2014 at 4:26 am
Viewing 15 posts - 2,986 through 3,000 (of 9,244 total)