Viewing 15 posts - 1,831 through 1,845 (of 9,244 total)
That won't dump specific permission grants, which is what you requested
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 10, 2015 at 12:51 am
As suggested run restore filelistonly against the backup file and post back the results
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 10, 2015 at 12:46 am
ray santalis-466762 (8/6/2015)
\as2\sqlbackups\SERVERNAME
This is not a properly formed UNC path
its been discussed recently on this forum but I can't see the point of using robocopy and wrapping it in a...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 7, 2015 at 1:22 am
His username is edvassie
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 7, 2015 at 1:09 am
Eddie Wuerch (8/6/2015)
Transaction log backups should still come from the primary replica, as this is the only way to clear out inactive entries in the transaction log file.
This is incorrect,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 6, 2015 at 10:34 am
Paresh Motiwala (8/6/2015)
one more thing.There are three phases in the job
lsbackup- works
lscopy- fails
lsrestore- kinda works because there are no files to apply; since copy failed.
Correct, there are 3 jobs for...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 6, 2015 at 9:30 am
This is my script, feel free to use it, I'm constantly updating and improving it
SET NOCOUNT ON
DECLARE @sql NVARCHAR(MAX)
DECLARE @majver INT
DECLARE @minver INT
DECLARE @build VARCHAR(16)
SET @sql = ''
SET @build...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 6, 2015 at 9:27 am
is the sql server service running under a domain account or local account?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 6, 2015 at 9:03 am
Part-time DBA (8/6/2015)
would it be feasible to install the cluster instance on server 2 under a new name then rename it to the server one name on the implementation day?
Yes,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 6, 2015 at 9:02 am
FTdenali (8/6/2015)
HiWould it be possible to disjoin the SQL Server Clustered environment to a new domain without having to reinstall the cluster?
No, the cluster is domain dependant.
FTdenali (8/6/2015)
e.g 2 node...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 6, 2015 at 8:40 am
the author of finebuild is a member of this forum, you could try contacting him directly
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 6, 2015 at 8:33 am
Part-time DBA (8/6/2015)
Perry, I think I am going to switch to your suggested sequence
Building the single node cluster on server 2 and keeping server 1 up as a temporary name...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 6, 2015 at 6:43 am
Where do I start, the beginning probably
You shouldn't do this
Part-time DBA (8/6/2015)
2. Create four iSCSI shared volumes (for quorum, MSDTC, databases and logs.) Volumes will be connected to both servers,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 6, 2015 at 5:12 am
sql finebuild will auto install a sql server environment for you, you can find it here[/url]
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 6, 2015 at 4:49 am
New persopn (8/6/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 6, 2015 at 4:47 am
Viewing 15 posts - 1,831 through 1,845 (of 9,244 total)