Viewing 15 posts - 5,086 through 5,100 (of 9,244 total)
soccer (9/4/2012)
Secondly, I installed SQL on the new server and added the node into the SQL cluster. The logs indicates clear...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 6, 2012 at 1:10 am
You can do, but i don't use it.
I, and I'm sure many others, create files based on date, much easier to manage.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 5, 2012 at 11:51 pm
jheim (9/4/2012)
Good article. Covered the basic configurations that people are "thinking about". Thanks.
Please do not forget to rate the article if you found it useful
jheim (9/4/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 5, 2012 at 5:04 am
yes xp_delete_file was fixed in SP2 but i have seen issues re appear in SP4. I generally use a VB script to manage file removal of backups and logs
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 5, 2012 at 3:57 am
Marios Philippopoulos (9/5/2012)
I had initialized it previously using a manual "RESTORE DATABASE ... WITH STANDBY ..." command.Is that why it is not showing up?
So what path\filename did you specify for...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 5, 2012 at 3:54 am
nulls would indicate that although the backup and copy are running no logs are being restored, there can be many different reasons why this happens.
Carefully check the job step history...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 5, 2012 at 3:53 am
zahid_7777 (8/10/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 5, 2012 at 1:40 am
ananda.murugesan (9/5/2012)
Hi,1. Principal & mirror server result the same role, Is it correct for FULL safty configuration without wittness?
SELECT roleFROM sys.database_mirroring_endpoints;
Role = 1 (partner)
both instances are partners in the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 5, 2012 at 1:32 am
What version is your sql server instance at?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 4, 2012 at 11:56 pm
Grant Fritchey (9/4/2012)
The 2012 install process is not radically different from the 2012 install process.
The install process between 2005 and 2012 is radically different.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 4, 2012 at 4:20 pm
Robert Davis (9/4/2012)
Great idea, Perry!
😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 4, 2012 at 2:52 pm
Marios Philippopoulos (9/4/2012)
Perry Whittle (9/4/2012)
the column is called 'backup_destination_directory'That location contains the log backups copied to the standby from the principal. There is no standby file there.
yes it does and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 4, 2012 at 2:50 pm
confirm what steps you took to add the node into the windows cluster and into the clustered sql server instance
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 4, 2012 at 2:43 pm
the column is called 'backup_destination_directory'
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 4, 2012 at 2:41 pm
Suresh B. (8/29/2012)
Orphaned users situation araises only if the login does not exist. If the logins exist, no orphansed users.
This is incorrect!!
The login may exist on the new server but...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 4, 2012 at 1:54 pm
Viewing 15 posts - 5,086 through 5,100 (of 9,244 total)