No announcements
Found 2450438 threads
-
0 VotesRead_Only and Read_Write File Groups in Same Database
are advantanges of RO file groups/db's regarding locking.Answered | 4 Replies | 1003 Views | Created by abeljda - Thursday, June 12, 2014 5:09 PM | Last reply by RAJU RG - Thursday, June 12, 2014 10:37 PM
-
2 Votes
check if database is READ_WRITE then running backup
IF (SELECT (DATABASEPROPERTYEX('DatabaseName','Updateability'))) = 'READ_WRITE' BEGIN print 'Proceed to take the backup' END else print 'The ...Answered | 6 Replies | 1315 Views | Created by RayRay_dba - Friday, May 17, 2019 9:12 AM | Last reply by RayRay_dba - Tuesday, May 21, 2019 10:00 PM -
2 Votes
Creating Read_Only Database in SQL Azure?
he's probably referring to the ALTER DATABASE SET READ_ONLY option in SQL Server ALTER DATABASE AdventureWorks2012 SET ...Answered | 2 Replies | 5894 Views | Created by Mahesh Deshpande - Monday, April 9, 2012 1:56 AM | Last reply by JuneT - Tuesday, April 10, 2012 2:37 AM -
1 Votes
Making data change in read_only database without letting other users update data
Reminding: Read_only database can not be set single_user mode.Answered | 5 Replies | 1074 Views | Created by Sql server Admin - Thursday, August 6, 2015 1:30 PM | Last reply by Sql server Admin - Monday, August 10, 2015 11:00 AM -
0 Votes
Problem with restore read_only filegroup
I want to restore only read_write filegroups without any problems with read_only filegroups.Answered | 7 Replies | 7359 Views | Created by greendraw - Tuesday, July 12, 2011 8:32 AM | Last reply by John Sansom - Wednesday, July 13, 2011 7:22 AM -
0 Votes
SQL Server 2014 Always ON - Secondary Replica Application Intent Apply READ_WRITE
HI douglas, Secondary replica cannot be applied configuration of Application Intent = READ_WRITE .Answered | 1 Replies | 1193 Views | Created by douglas foong - Tuesday, February 10, 2015 9:30 AM | Last reply by Lydia Zhang - Wednesday, February 11, 2015 5:59 AM -
2 Votes
I have detached a database, moved files to another logical drive, attached the base again, but it shows up as READ-ONLY, why, what to do?
SOLUTION: Both were neccesary in my case: - give ALL privileges of FULL CONTROL to a file AND - alter ...Answered | 3 Replies | 412 Views | Created by Tomek5 - Thursday, July 13, 2017 3:43 PM | Last reply by Tomek5 - Friday, July 14, 2017 9:35 AM -
0 Votes
After setting database read_only if i take transaction log backup with no truncate , does it have side affect?
Thanks Swapna Did you got the same error ?Answered | 11 Replies | 1100 Views | Created by Sql server Admin - Friday, July 18, 2014 12:18 PM | Last reply by TiborK - Saturday, July 19, 2014 7:35 PM -
0 Votes
Database File Groups
In one of our database there is a table with 86mb data space in order to test I have inserted this data into a new database with two files (.mdf & .ndf) in a single ...Answered | 9 Replies | 906 Views | Created by Kalyan Chakravarthi (MCP) - Wednesday, December 23, 2015 1:33 PM | Last reply by Kalyan Chakravarthi (MCP) - Thursday, December 24, 2015 4:24 AM -
2 Votes
can we have same file group name for two different databases??
Thanks Nag Pal...You are right.....I needed to change the physical file name......The file group name was the same....thanks,,,HarryAnswered | 3 Replies | 5389 Views | Created by Harry SQL DBA - Friday, August 26, 2011 8:32 PM | Last reply by Harry SQL DBA - Monday, August 29, 2011 4:05 AM -
0 Votes
Visual Studion 2013 Database Project Publish Post Deploy Script and Check Constraint order problem
Miscellaneous -> Database Access" to READ_ONLY.Answered | 2 Replies | 1166 Views | Created by abeljda - Thursday, June 12, 2014 2:58 PM | Last reply by abeljda - Saturday, August 23, 2014 3:39 PM -
1 Votes
Grant select to READ_ONLY DATABASE
You can create a new user group in active directory and grant this group read only access.Answered | 3 Replies | 6863 Views | Created by darakmao - Tuesday, June 29, 2010 4:37 PM | Last reply by darakmao - Wednesday, June 30, 2010 4:03 PM -
2 Votes
BACKUP LOG cannot be performed because there is no current database backup.
create database TajMahal go alter database TajMahal set recovery full with no_wait go alter database TajMahal set read_only with ...Answered | 10 Replies | 49482 Views | Created by Jacob Mansfield [ITVET Limited] - Wednesday, December 5, 2012 10:38 AM | Last reply by Balmukund - Sunday, December 9, 2012 2:40 AM -
2 Votes
Two Database instance with database on same data files
An AlwaysOn Failover Cluster Instance allows two database servers to share the same set of database and log files.Answered | 5 Replies | 3084 Views | Created by Aapuci - Monday, September 2, 2013 3:04 PM | Last reply by davidbaxterbrowne - Monday, September 2, 2013 4:06 PM -
0 Votes
Back File Group and Restore File Group Issue
Hi SQL, We cannot restore the specific file and filegroup from a database to another existing database, we can only restore filegroup ...Answered | 6 Replies | 1168 Views | Created by SQL Backup and Restore File Group Issue - Wednesday, May 4, 2016 4:03 PM | Last reply by Jason_Clark03 - Tuesday, May 10, 2016 5:17 AM -
0 Votes
File Groups in Databases
Files and filegroups are database-scoped.Answered | 4 Replies | 881 Views | Created by mahalakshmi ambalavanane - Tuesday, May 20, 2014 6:14 AM | Last reply by Dan Guzman - Tuesday, May 20, 2014 12:20 PM -
0 Votes
Add new file group to existing database
Also will there be any performance improvement in creating new file group in same drive as primary file group and assigning only a set of rows of a ...Answered | 9 Replies | 2012 Views | Created by Preetha7 - Tuesday, June 24, 2014 3:06 AM | Last reply by Kartar Rana - Tuesday, June 24, 2014 3:19 PM -
0 Votes
Restoring a file group database in SQL 2005 Server
I think I understand so far, however, I have file groups that span multiples files in the same directory with just a different file ...Answered | 14 Replies | 2682 Views | Created by Louisb - Thursday, July 25, 2013 9:35 PM | Last reply by Fanny Liu - Wednesday, July 31, 2013 12:11 PM -
0 Votes
Recover database from .mdf and .ldf only in SQL2008
First try to change the mode to READ_WRITE.Answered | 1 Replies | 6735 Views | Created by coastaldamage - Friday, October 30, 2009 4:42 AM | Last reply by Varsham Papikian - Friday, October 30, 2009 5:34 AM -
1 Votes
T-Sql script to make all Databases to Read-only mode in sql server 2012
Databases need to be in single_user in order to make them readonly.Answered | 2 Replies | 13254 Views | Created by BomaSri - Thursday, September 12, 2013 6:32 PM | Last reply by SRichards - Monday, September 16, 2013 2:06 PM - Items 1 to 20 of 2450438 Next ›
No announcements
