Viewing 15 posts - 5,071 through 5,085 (of 6,679 total)
The first question to ask is why do you want to shrink the database? If this is a one time operation, then you really need to look at shrinkfile...
May 31, 2009 at 9:52 am
SQL Server 2008 Express Edition is the freely available version from Microsoft. There is no trial period associated with that version.
SQL Server, including the express edition, is not registered...
May 30, 2009 at 2:02 pm
Are you restoring from a file on the network? Or is the file local? The I/O system is usually what causes restore rates to be fast or slow...
May 30, 2009 at 1:58 pm
This is happening because you are backing up across the network and there is a blip on the network. The ideal solution is to backup locally and copy to...
May 30, 2009 at 1:55 pm
I have seen something similar before - where using a login with sysadmin privileges bypasses certain checks and error messages.
This is just one of the many reason why it is...
May 30, 2009 at 1:50 pm
Is the server the database is setup on dedicated to SQL Server?
Did you set the lock pages in memory option?
Did you set the max memory appropriately?
May 30, 2009 at 1:48 pm
MCHPIS (5/29/2009)
May 29, 2009 at 9:31 pm
I'm sorry - but I still don't get it.
On the client, we are running Windows XP SP2 Professional (x86). The client machine knows nothing about x64, doesn't know anything...
May 29, 2009 at 5:14 pm
Gift Peddie (5/29/2009)
.... on occasion there is an ambiguous error, at other times the application simply dies on the local workstation
The above is the reason for my statement and a...
May 29, 2009 at 4:36 pm
You are welcome - let use know if there is any additional help you need.
May 29, 2009 at 9:22 am
Glad I could help and you are now able to get this to complete.
May 29, 2009 at 9:20 am
You are welcome, I am happy I was able to help.
May 29, 2009 at 9:18 am
You've got to be kidding, right?
failed with the following error: "Online index operation cannot be performed for index 'PK__DTA_input__009508B4' because the index contains column 'TuningOptions' of data type text, ntext,...
May 28, 2009 at 8:53 pm
Column statistics are not updated during and index rebuild. Index statistics are updated for the index being rebuilt.
May 28, 2009 at 4:51 pm
PaulB (5/28/2009)
Here is how you do it.
1- Pre-create the database in your "target" server -so you make all decisions about storage.
2- Force-restore over the pre-created database -so datafiles go to...
May 28, 2009 at 4:26 pm
Viewing 15 posts - 5,071 through 5,085 (of 6,679 total)