Viewing 15 posts - 6,691 through 6,705 (of 9,244 total)
Adrian Smith-294236 (9/1/2011)
I have a maintenance plan that deletes backup histories
That wont cleanup the LS agent histories. The following stored procedure is used to cleanup agent history based on the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 1, 2011 at 3:03 am
what steps are you taking to prune history?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 1, 2011 at 2:56 am
BigSam (8/31/2011)
I followed the information in Microsft's guide
http://msdn.microsoft.com/en-us/library/ms191295.aspx
I've upgraded the passive node to R2, but...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 1, 2011 at 2:53 am
More importantly the OP hasn't provided details of the storage on the stand alone server which i'm asuming is using local disks unless told otherwise
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 1, 2011 at 2:47 am
Could you execute the following and return the results for disk6
wmic partition get BlockSize, StartingOffset, Name, Index, type, primarypartition
robster (8/31/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 1, 2011 at 2:23 am
Do you have the diskpart commands to create the new partitions
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 31, 2011 at 5:30 pm
Sql server 2000 standard does not support log shipping!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 31, 2011 at 2:33 pm
What edition is your SQL 2000 instance?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 31, 2011 at 2:18 pm
Ok but if you log ship between 2000 and 2008 the database can only be in restoring mode!!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 31, 2011 at 2:09 pm
Ok so if youre moving a copy to dev why are you log shipping it? The log shipped database will not be in a state that will allow access to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 31, 2011 at 1:51 pm
if you're going to wipe the partition and format it, change the disk from Dynamic to Basic before creating the new partition!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 31, 2011 at 12:52 pm
why would you want a dev database that is in restoring state?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 31, 2011 at 12:50 pm
So if you dont have a domain where are you getting this from????
Marcondes Josino Alexandre (8/30/2011)
SET PARTNER = 'TCP: / / fortes01.secran.com.br: 1400'
To set up mirroring for a workgroup you...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 30, 2011 at 2:07 pm
Marcondes Josino Alexandre (8/30/2011)
I am deploying SQL Server 2005 Database Mirroring here at the University with a database with compatibility level 80 where we as an...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 30, 2011 at 1:15 pm
Please execute the folowing against your instance and post the result
select SERVERPROPERTY('edition')
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 30, 2011 at 9:42 am
Viewing 15 posts - 6,691 through 6,705 (of 9,244 total)