[MS SQL Server] Right click on a Database, select properties Error, cannot show requested dialog. |
- Right click on a Database, select properties Error, cannot show requested dialog.
- SQl 2008 R2 enterprise edition compressedn backup to be restored Standard edition
- Understanding minimal logging using INSERT... SELECT
- Full backups on any database, will it affect the LSN chain ?
- Will Transactional Log Backups slow the growth of Database Log file
| Right click on a Database, select properties Error, cannot show requested dialog. Posted: 02 Jul 2013 11:54 PM PDT I right click on a Database, select properties Error, cannot show requested dialog.The error reads:cannot show requested dialog (SqlMgmt)Property Size is not available for Database '[DataWarehouse]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SQLServer.Smo)I'm running Database Consistency Checker.Has anyone experienced this problem? |
| SQl 2008 R2 enterprise edition compressedn backup to be restored Standard edition Posted: 16 Jul 2013 10:29 PM PDT HiI have a SQL 2008 R2 enterprise edition compressedn backup which is to be restored on SQl 2008 R2 Standard edition. I see from MSDN that it can be done but how to do that? Will simple restore command work or there is difference in Restore command.I did a RESTOR Verify only on Standard edition and it failed although passed on Enterprise edition.Thanks |
| Understanding minimal logging using INSERT... SELECT Posted: 16 Jul 2013 09:47 PM PDT Hi All,I'm trying to understand more about minimal logging for the INSERT... SELECT operation in SQL Server.I have a database in the simple recovery model, and a clustered table that's about ~20GB in size; and I want to create an exact duplicate of that table. The table does have an IDENTITY(1,1) column, but that is [i]not[/i] the cluster of the table; I mention this cause I don't know whether that will make a difference. As such, the insert statement has to be preceded with SET IDENTITY INSERT ON for the table.My transaction log for that database is presized to 20GB, with 16 vlogs when I run a DBCC LOGINFO. Autogrowth is set to grow in 5GB chunks with no upper restriction.If I run the insert with TABLOCK, it seems to still being fully logged, my t-log gets full and starts autogrowing. I'm not using an ORDER BY clause on my select however; would this affect the operation? Both tables are clustered with the same key, however.I've also tried using trace flag 610 which seemed to stop the log from growing at first, but then it started to grow at a tiny incremental and generated a fresh set of vlogs for each incremental, resulting in > 5000 being created.If DDL is needed, I'm happy to post, but not sure whether that will add anything in this instance so I haven't prepared it yet.Cheers,Matthew |
| Full backups on any database, will it affect the LSN chain ? Posted: 16 Jul 2013 10:20 PM PDT Hi All,Have one situation...If we take full backup .. will it be affect the LSN Chain. Please reply me |
| Will Transactional Log Backups slow the growth of Database Log file Posted: 16 Jul 2013 05:32 PM PDT Could somebody please clear up the confusion I'm having.Is it correct to say that if I do transactional log backups it will reduce or slow the rate of growth of the Database log file(.ldf), whereby shrinking the database log file will not be needed as this causes disk defragmentation if carried out for a long time....Problem is I have huge Database Log files(.ldf) which adds up after few weeks/months causing me to run out of disk space... |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2008 / SQL Server 2008 Administration To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
No comments:
Post a Comment