Viewing 15 posts - 5,446 through 5,460 (of 9,244 total)
Roust_m (6/19/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 20, 2012 at 7:17 am
Roust_m (6/18/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 20, 2012 at 7:16 am
Check the status of your mirror sesion firstly, log records that have not been transferred cannot be truncated and often cause the log to grow wildly.
Also check the status of...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 19, 2012 at 8:30 am
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
Viewing 15 posts - 5,446 through 5,460 (of 9,244 total)