Viewing 15 posts - 76 through 90 (of 90 total)
Thanks Lynn. Anyway to automate this or do you do it manually? We have many servers and databases.
April 26, 2010 at 8:46 am
Brandie Tarvin (4/1/2010)
chrisph (3/31/2010)
I would check/ask if they have "volume shadow copy" enabled on...
April 2, 2010 at 10:42 am
Is it possible the server team could go back and restore the .mdf from their backup procedures?
I would check/ask if they have "volume shadow copy" enabled on the server. ...
March 31, 2010 at 8:31 am
From this article (http://www.developer.com/db/article.php/3446891/Understanding-SQL-Server-Full-Text-Indexing.htm)
it brings out that these full-text searches are done through T-SQL and use predicates such as: FREETEXT / FREETEXTTABLE / CONTAINS / CONTAINSTABLE
Also whenever you...
March 30, 2010 at 1:46 pm
Some things I would check would be:
1. SQL Server Configuration Manager - is the FullText Search service running properly (set to Automatic and actually running)?
2. In the specific Database properties,...
March 30, 2010 at 11:44 am
I agree on the DBA(s) handling this CirquedeSQLeil. The reason I ask is there might be a need that this be done weekly, I will have to learn more...
March 11, 2010 at 4:30 pm
Is there a way for the user to do this himself, without necessarily giving him sysadmin privileges to the server?
Would the Copy Database Wizard be better in this case?
March 11, 2010 at 8:01 am
The problem I was having was that the source DB files were located on a different drive letter (not the default location), which the destination server didn't have.
In the Restore...
March 10, 2010 at 3:26 pm
Is it necessary for me to copy over the .mdf and .ldf files from the source server to the destination server?
I cannot point to the original .mdf and .ldf files...
March 10, 2010 at 2:53 pm
As an update we went ahead with the detach/attach, as this is what the DB programmer suggested in the end for convenience.
I am still puzzled as to why people...
March 2, 2010 at 9:01 am
Thanks guys.
Is there a difference as to how user accounts are transfered over using restore vs. detach/attach, or if they are transfered at all?
March 1, 2010 at 10:27 am
Thanks for the quick replies guys. The DB is just in it's infancy, there is only one login so far, so as far as that goes it shouldn't be...
March 1, 2010 at 9:29 am
Viewing 15 posts - 76 through 90 (of 90 total)