Viewing 15 posts - 5,086 through 5,100 (of 9,241 total)
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
dan-572483 (9/4/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 4, 2012 at 1:51 pm
you're welcome 😎
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 4, 2012 at 1:45 pm
Usually its set to the secondary destination directory which you can get from the following
exec sp_help_log_shipping_secondary_database 'yourdb'
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 4, 2012 at 1:38 pm
Viewing 15 posts - 5,086 through 5,100 (of 9,241 total)