Viewing 15 posts - 1,366 through 1,380 (of 9,253 total)
SQL Galaxy (2/17/2016)
I want simulate and testing the following failure scenario in Alwayson Group.
1.Shutdown Primary Node 1 & 2 and including FSW,
a. In this cause what will be...
February 17, 2016 at 10:25 am
VMware support Windows 2012 as a guest OS system, so yes you can
February 16, 2016 at 10:29 am
himanshu.sinha (2/13/2016)
1 .FInd the latest backup from the folder on server A .
easy via Powershell, something similar to this
$checkpath = "C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\*.*"
$result = get-childitem $checkpath -Include *.bak |...
February 15, 2016 at 7:46 am
Orlando Colamatteo (2/13/2016)
February 15, 2016 at 7:05 am
kiasystemsoft (2/12/2016)
Sorry , I have only a database file and I have not password
Which server did the database backup file come from?
You need to take a backup of the certificate...
February 15, 2016 at 5:29 am
kiasystemsoft (2/11/2016)
HiExcuseme
I can not speek English well
I have a database
It is tde encryption and I forget password
I want for attach this database
Please Help me
You just need...
February 12, 2016 at 5:57 am
Sorry, I'm confused, you say
PiMané (2/11/2016)
The recovery mode should be FULL, since the primary data is very, very important..
Then you say
PiMané (2/11/2016)
February 12, 2016 at 5:55 am
Furthermore, BOL states the following for TRUNCATE TABLE
Books OnlinePermissions
The minimum permission required is ALTER on table_name. TRUNCATE TABLE permissions default to the table owner, members of the sysadmin fixed server...
February 11, 2016 at 10:22 am
go test it yourself!!
ALTER ANY SCHEMA is implied by DB_DDLAdmin, this grants alter across any schema and so across any table.
I've just done exactly the same myself
February 11, 2016 at 9:48 am
DBANewbie (2/11/2016)
Thanks very much. Could we try rebuilding those indexes or would any corruption on the data prevent the index from rebuilding?
as Gail said, drop the indexes, run DBCC CHECKTABLE...
February 11, 2016 at 9:33 am
SQLSlammer (2/11/2016)
ddl_admin does not have alter table, it does seem to have alter everything else though.
This is incorrect, DB_DDLadmin provides ALTER on any schema which provides ALTER and so TRUNCATE...
February 11, 2016 at 9:28 am
SQL!$@w$0ME (2/11/2016)
How do I provide permissions to truncate one table in a db without giving DDL_Admin rights?
To provide permissions to a user to truncate a single table you need to...
February 11, 2016 at 9:22 am
alex.sqldba (2/10/2016)
Hi Perry,This is what my configuration looks like now after some tweaking based on your reply:
GLSQCOL3010|TCP://GLSQCOL3010.blah.local:5022|SYNCHRONOUS_COMMIT|AUTOMATIC|ALL|READ_ONLY|TCP://GLSQCOL1010.blah.local:1433
GLSQCOL1010|TCP://GLSQCOL1010.blah.local:5022|SYNCHRONOUS_COMMIT|AUTOMATIC|ALL|READ_ONLY|TCP://GLSQCOL3010.blah.local:1433
GLSQCOL3010|TCP://GLSQCOL3010.blah.local:5022|SYNCHRONOUS_COMMIT|AUTOMATIC|ALL|READ_ONLY|TCP://GLSQCOL3010.blah.local:1433
GLSQCOL1010|TCP://GLSQCOL1010.blah.local:5022|SYNCHRONOUS_COMMIT|AUTOMATIC|ALL|READ_ONLY|TCP://GLSQCOL3010.blah.local:1433
My script was just an example, you may not want to specify every replica...
February 10, 2016 at 3:54 am
alex.sqldba (2/9/2016)
Right, well i did the following:
ALTER AVAILABILITY GROUP [ingeus2]
MODIFY REPLICA ON N'GLSQCOL1010'
WITH (SECONDARY_ROLE (READ_ONLY_ROUTING_URL = 'TCP://GLSQCOL1010.blah.local:1433'));
ALTER AVAILABILITY GROUP [ingeus2]
MODIFY REPLICA ON N'GLSQCOL3010'
WITH (SECONDARY_ROLE (READ_ONLY_ROUTING_URL = 'TCP://GLSQCOL3010.blah.local:1433'));
Followed...
February 9, 2016 at 10:54 am
ScottPletcher (2/9/2016)
Perry Whittle (2/9/2016)
Luis Cazares (2/8/2016)
February 9, 2016 at 9:37 am
Viewing 15 posts - 1,366 through 1,380 (of 9,253 total)