Viewing 15 posts - 6,541 through 6,555 (of 49,571 total)
No.
When you restored, you overwrote the old DB. Anything in there is gone, unless there was a full or differential backup taken between the times the user made the changes...
February 17, 2015 at 3:13 am
Because, for some reason, the log file (the .ldf file) is not accessible to SQL Server. Without a pile more information, that's about all that can be said
February 17, 2015 at 1:51 am
You can use the server-side trace feature. Express may not have the profiler GUI, but it's still got the trace feature. You'll just have to write up your own trace...
February 17, 2015 at 1:49 am
Anyone going to be at SQL Sat Vienna? It's the Saturday before SQLBits.
February 17, 2015 at 1:44 am
No. Replication allows for different indexes, different procedures/views, but the tables should be the same structure.
February 17, 2015 at 1:35 am
You have the advantage of me then, since I can't test.
Lowell's query is much what I would write if I was writing a query blind (no tables, no data) with...
February 16, 2015 at 6:24 am
If you don't want a tested solution, cool, your choice.
Look at Row_Number and the partition by clause, you can then filter on that value to get just the highest. Should...
February 16, 2015 at 6:16 am
Table definitions (as CREATE TABLE statements), sample data (as INSERT statements) and expected results please.
February 16, 2015 at 5:45 am
No, it won't block users, but it will slow things down and you will need to rebuild indexes afterwards and that will block users (unless it's an online rebuild)
If your...
February 16, 2015 at 5:03 am
The first, you can check in the shrink dialog, the second there's no way to determine
First however, why are you shrinking the database?
Unless you've just done some major archiving or...
February 16, 2015 at 4:34 am
Backup/restore strikes me as the easiest solution.
February 16, 2015 at 4:13 am
I hate seeing that in queries.
February 16, 2015 at 4:12 am
TheSQLGuru (2/13/2015)
GilaMonster (2/13/2015)
TheSQLGuru (2/12/2015)
February 16, 2015 at 2:52 am
There's no 'unless'. TDE protects data at rest only, it only prevents you from restoring or attaching the database to an instance without certificates. Nothing else.
What's the ultimate goal here,...
February 16, 2015 at 2:49 am
On SQL 2005 (this forum), no.
On SQL 2012, no.
On SQL 2014, yes.
February 16, 2015 at 2:45 am
Viewing 15 posts - 6,541 through 6,555 (of 49,571 total)