Viewing 15 posts - 5,446 through 5,460 (of 9,241 total)
Ratheesh.K.Nair (6/18/2012)
Again you have to restore the new master with your master backup file otherwise it wont read your user databases it will all greyed as ur new master...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 18, 2012 at 9:20 am
You should definitely be looking to consolidate here where possible.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 15, 2012 at 12:20 pm
kevinsql7 (6/15/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 15, 2012 at 11:08 am
kylemkr85 (6/15/2012)
I have a question regarding an ACTIVE/ACTIVE Cluster enviornment using SQL Server 2008 R2. We have several instances of SQL which we currently need to migrate from SQL 2005...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 15, 2012 at 11:01 am
ganeshkumar005 (6/13/2012)
After feeding all the things in log shipping configuration monitor, what I get is Alert job and log backup job created on Primary but...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 15, 2012 at 10:53 am
Laura Schmalzbauer (6/15/2012)
ok thank you for the replies. This confirms my suspicions.
it's also vital to get the server name correct in the linked server. You may even have ports...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 15, 2012 at 10:46 am
check the application event log for further sql server startup error messages and post them back
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 15, 2012 at 9:17 am
You'll need to ensure any ports are open and also, since the servername SERVER=xxx.xx.xx.xxx won't exist or be resolvable, when creating the linked server change this code portion
@datasrc='SERVER=xxx.xx.xx.xxx'
To this
@datasrc='xxx.xxx.xxx.xxx'
or this
@datasrc='myservername'
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 15, 2012 at 9:10 am
deep_kkumar (6/13/2012)
If the retention period is set to 12 hrs on the copied files. If...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 15, 2012 at 7:18 am
I work with Oracle and SQL server databases, the biggest unknown usually comes when the Oracle instance is running on Unix. Unix servers can be difficult to master and that...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 15, 2012 at 7:00 am
OLDCHAPPY (6/15/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 15, 2012 at 6:49 am
based on this......
SQLSACT (6/12/2012)
Forget about Server3 - Doesn't exist
We have a 2 Node Cluster with servers Server1 & Server2
In a different geographic location (on the same...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 13, 2012 at 1:12 am
In my opinion you would probably be better off with subversion?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 13, 2012 at 1:00 am
One option might be to use either Veritas Cluster Server or HP Polyserve.
Above that you can, if using Enterprise or Datacenter editions, use scale out deployments where multiple web front...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 13, 2012 at 12:58 am
k.subramanyam1017 (6/12/2012)
I have alredy installed sqlserver in 'c' drive but i want to change the 'd' drive. is it possible or not pls...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 13, 2012 at 12:49 am
Viewing 15 posts - 5,446 through 5,460 (of 9,241 total)