Viewing 15 posts - 1,366 through 1,380 (of 9,244 total)
VMware support Windows 2012 as a guest OS system, so yes you can
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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 |...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 15, 2016 at 7:46 am
Orlando Colamatteo (2/13/2016)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 9, 2016 at 10:54 am
ScottPletcher (2/9/2016)
Perry Whittle (2/9/2016)
Luis Cazares (2/8/2016)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 9, 2016 at 9:37 am
Venki508 (2/7/2016)
Just for the confirmation..Iam new to the Sql SERVER database..
So dont we have like this export script in Sql SERVER
expdp username/password schemas=scott exclude=table:"IN('emp','history')" directory=data_pump_dir dumpfile=test.dmp...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 9, 2016 at 9:32 am
Viewing 15 posts - 1,366 through 1,380 (of 9,244 total)