Viewing 15 posts - 12,661 through 12,675 (of 49,553 total)
HildaJ (6/19/2013)
June 19, 2013 at 3:30 pm
Books Online. The RESTORE DATABASE page. I suggest you spend some time reading Books Online on a variety of topics. Maybe also buy a copy of one of the SQL...
June 19, 2013 at 2:11 pm
Learner44 (6/19/2013)
I already metioned I am new to this encryption field..
The steps I gave have little to do with encryption, more to do with basic database operations like restoring a...
June 19, 2013 at 2:05 pm
Really, you're working with encryption and you either don't know what a certificate is or don't know how to restore a backup on another server?
Leave off the encryption and spend...
June 19, 2013 at 1:59 pm
Learner44 (6/19/2013)
But Now I am confused..how I can show him, that database is encrypted and if your restore it won't without proper key.
To prove it won't restore without the certificate,...
June 19, 2013 at 1:44 pm
balasaukri (6/19/2013)
Hence please help me to free up space.
Why? SQL Server uses memory for performance reasons, disk access is slow. Why do you want to reduce its memory usage? All...
June 19, 2013 at 12:36 pm
If you're not going to answer my questions, I'm not going to help you.
As for the steps to restore a TDE-encrypted database, they're in Books Online.
To prove it won't restore...
June 19, 2013 at 12:32 pm
Learner44 (6/19/2013)
Msg 3234, Level 16, State 2, Line 2Logical file 'mydb' is not part of database 'Encry2'. Use RESTORE FILELISTONLY to list the logical file names.
And when you did what...
June 19, 2013 at 11:26 am
bslchennai (6/19/2013)
can we use WITH(NOLOCK) option in select queries for these tables. how it will work.
Will the users be happy if the data that the queries return is inconsistent...
June 19, 2013 at 11:24 am
Sai Viswanath (6/19/2013)
Also, could you point out which part of the output has got incorrect structure.
The SELECT *, the fact that it's across a linked server, the lack of a...
June 19, 2013 at 11:21 am
Krishna1 (6/19/2013)
How do I test this. I need to show the diff that log will not get trucated even if we take full back every day.
Create a database, set...
June 19, 2013 at 8:59 am
Modest DBA (6/19/2013)
so what you telling me is that due to contention my set up should be as follows...6 CPU machine and 6 LUNS allocated for mdfs.
No, I'm not necessarily...
June 19, 2013 at 8:58 am
Because TempDB is prone to allocation contention (contention on the allocation pages in the data file), a contention that is alleviated by having more than one file and because there...
June 19, 2013 at 8:43 am
SQLSACT (6/19/2013)
The difference between the elapsed time and the worker time could be because of any wait type, right?
Correct, and you could miss queries that have waited, because of...
June 19, 2013 at 8:20 am
Viewing 15 posts - 12,661 through 12,675 (of 49,553 total)