Viewing 15 posts - 2,986 through 3,000 (of 9,241 total)
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
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
Viewing 15 posts - 2,986 through 3,000 (of 9,241 total)