Viewing 15 posts - 12,526 through 12,540 (of 49,557 total)
There will be messages in the SQL error log saying why the DB was marked suspect. Have a look through the error log, look for messages relating to the database,...
July 1, 2013 at 8:19 am
Operating system error 5 is Access Denied. The SQL Server service does not have full rights on that folder.
p.s. sp_attach_db is deprecated and should not be used. Use CREATE DATABASE...
July 1, 2013 at 7:52 am
What does the SQL error log say?
What backups do you have?
July 1, 2013 at 7:51 am
GilaMonster (12/14/2011)
logicinside22 (12/14/2011)
Is there any other way rather than to DROP?
You can try RESTORE WITH RESTART, but unless the restore time is horrendous, probably unnecessary. The option's intended for absolutely...
July 1, 2013 at 7:20 am
The query given above has a number of unnecessary filters in it (as mentioned earlier) that will result in some queries that do table scans not showing up. The given...
July 1, 2013 at 7:19 am
Did you read part 2?
You get the code for the procedures by going to the server and scripting the procedure out, you get the performance characteristics by running the procedure...
July 1, 2013 at 3:56 am
Multiple tables is little different from one table.
June 30, 2013 at 11:51 am
Hopefully including:
Test all changes on a non-production system
Don't delete database files.
June 30, 2013 at 6:26 am
There's nothing there of any use. Are there any logs anywhere with more details?
June 30, 2013 at 3:55 am
https://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-start/
Not the sections on model and tempDB, you've messed that up beyond repair, the section on master, on rebuilding the system databases.
Rebuild them, then restore backups of master and msdb,...
June 29, 2013 at 4:37 pm
Change Data Capture, Change Tracking, triggers. All viable options.
June 29, 2013 at 11:55 am
June 29, 2013 at 10:47 am
Viewing 15 posts - 12,526 through 12,540 (of 49,557 total)