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...
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...
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,
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...
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...
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
...
February 5, 2015 at 11:47 am
Srl832 (2/5/2015)
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!...
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...
February 5, 2015 at 10:39 am
sarath.tata (2/5/2015)
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...
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.
February 5, 2015 at 8:08 am
Lowell (2/5/2015)
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...
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...
February 4, 2015 at 1:14 am
Viewing 15 posts - 376 through 390 (of 1,170 total)