Viewing 15 posts - 376 through 390 (of 1,170 total)
Perry Whittle (2/12/2015)
Igor Micev (2/10/2015)
I have restored the master key from the instance where the encrypted backup was created on the instance where I want to restore the encrypted backup
Just...
Igor Micev
February 12, 2015 at 9:22 am
Perry Whittle (2/10/2015)
Igor Micev (2/10/2015)
I have an issue to restore an encrypted backup via GUI.
I can restore an encrypted backup on another instance using t-sql command, but cannot do...
Igor Micev
February 11, 2015 at 12:47 am
Hi Perry,
Can you take a look on the following topic http://www.sqlservercentral.com/Forums/Topic1659105-3411-1.aspx
Thanks,
Igor Micev
February 10, 2015 at 6:46 am
Thanks. At least I now know others have had the same issue. It should be reported to Microsoft to fix it.
But if you read this article you'll see that Perry...
Igor Micev
February 10, 2015 at 6:36 am
Srl832 (2/5/2015)
If you don't mind, could you tell me what are some of the other ways? I would like to learn various different ways if possible.Thanks
If you're on sql...
Igor Micev
February 6, 2015 at 12:58 am
Srl832 (2/5/2015)
that's exactly my question. How do I find out which process had a role in making the log bigger?
Try with this query
SELECT creation_time
...
Igor Micev
February 5, 2015 at 11:47 am
Srl832 (2/5/2015)
Igor Micev
February 5, 2015 at 11:29 am
Alan.B (2/5/2015)
Igor Micev (2/5/2015)
Alan.B (2/5/2015)
Or you can run DBCC FREEPROCCACHE & DBCC DROPCLEANBUFFERS (caution: this will cause other queries to slowdown as they will need to recompile).
No this!...
Igor Micev
February 5, 2015 at 11:23 am
Tell us how are your log files configured? What is the auto-growth?
You may have lots of virtual log files with small sizes and t-log shrinks don't help you.
This article is...
Igor Micev
February 5, 2015 at 10:39 am
sarath.tata (2/5/2015)
Igor Micev
February 5, 2015 at 10:36 am
Alan.B (2/5/2015)
Or you can run DBCC FREEPROCCACHE & DBCC DROPCLEANBUFFERS (caution: this will cause other queries to slowdown as they will need to recompile).
No this! It should never...
Igor Micev
February 5, 2015 at 10:28 am
What is your maintenance? Do you regularly rebuild/reorganize indexes?
Your case is typical for tables with not updated statistics.
Igor Micev
February 5, 2015 at 8:08 am
Lowell (2/5/2015)
Igor Micev
February 5, 2015 at 6:09 am
Try this
DECLARE @VName VARCHAR(256)
DECLARE Findlinked CURSOR LOCAL STATIC FORWARD_ONLY READ_ONLY
FOR
SELECT name AS name
FROM sys.servers
WHERE...
Igor Micev
February 5, 2015 at 2:26 am
If the backups are small (let's say up to couple of GBs) than you can proceed with a .sql file. The MySQL Workbench offers that via Server->Enterprise backup manager.
But for...
Igor Micev
February 4, 2015 at 1:14 am
Viewing 15 posts - 376 through 390 (of 1,170 total)