Viewing 15 posts - 5,581 through 5,595 (of 9,244 total)
soniaj (5/9/2012)
I added the windows login.
Which windows login?
What did you set the as password to during install?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 9, 2012 at 2:53 pm
Sql injection is not just about the code, permissions play a part too. Obviously, ensure the database connection has only the privileges it requires.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 9, 2012 at 12:43 pm
What did you set the sa password to during installation, did you add any windows logins during install?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 9, 2012 at 12:40 pm
surma.sql (5/9/2012)
but if i shrink log file, then it should work right?
Yes, but you'll need to shrink the log on the source system, take a fresh backup and then restore...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 9, 2012 at 12:39 pm
Ok, as you'll see if you search about you really want to avoid shrinking log files as they generally only grow again at a cost to performance.
Try to give...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 9, 2012 at 12:32 pm
ravisamigo (5/8/2012)
xp_cmdshell 'dir \\Server001\e$' - running in Server2
xp_cmdshell 'dir \\Server002\e$' - running in server1
OUTPUT : 'Access is denied.'
But I'm able to access through RUN(WIN+R) command from server1 to server2...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 9, 2012 at 10:10 am
Paul Beetge (5/7/2012)
Hi Guys,Except for the fact that the Quorum is down and SQL can still function, how did you fix the Quorum ?
Best start a new post, detailing your...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 7, 2012 at 11:28 am
iamsam.sandeep (5/7/2012)
1) if there are 2 sql instances in 2 node cluster how many tempdb drives will be adviced as per best practice
One for each instance 😉
iamsam.sandeep (5/7/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 7, 2012 at 11:26 am
For info cluster.log no longer exists on windows 2008. Open the fail over cluster manager and view events there. You can export cluster events to a log using the cluster.exe...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 7, 2012 at 11:24 am
Simha24 (5/7/2012)
I am Trying to create mirroring on different instance in Node N2 But it useses same Virtual Name
Forget the node names, for the most part in a cluster they...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 7, 2012 at 1:21 am
Thanks for your feedback, please don't forget to rate the article to.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 7, 2012 at 1:09 am
Use package variables to control execution against a test or live server child packages
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 6, 2012 at 3:37 pm
Simha24 (5/4/2012)
Cluster Name : CLU1NODE Name1: N1
NODE Name2:N2
DBName :PrincipalDB
When i am tring to implement mirroring N1 and N2 for db
PrincipalDB.
You can't create a mirror between 2 nodes in the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 6, 2012 at 2:54 pm
How many file groups do you use for the database?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 5, 2012 at 3:45 am
Most of them tend to be Linux orientated as the OS is free otherwise your NAS box would double in price.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 5, 2012 at 1:21 am
Viewing 15 posts - 5,581 through 5,595 (of 9,244 total)