Viewing 15 posts - 4,471 through 4,485 (of 49,571 total)
Try taking the filegroup offline. If that works, try dropping the files in it, followed by dropping the filegroup
October 19, 2015 at 6:54 am
You can, but you'll still have a defunct filegroup in the new database. The metadata of the DB knows that the database has 10 filegroups. If you restore all but...
October 19, 2015 at 6:35 am
If you're getting repeated corruptions, there's likely a problem with your IO subsystem. Do some investigation and see if you can identify the problem, before something important gets affected.
October 19, 2015 at 6:33 am
They're two completely different things, with completely different functions.
If you're running the DB in full or bulk-logged recovery models, you must take log backups. Whether that's as a manual process...
October 19, 2015 at 5:55 am
You can start by getting rid of some of those DISTINCTs. It's unnecessary to distinct at every level, the duplicates aren't going to creep back.
with Dates_ as
(select distinct Date_ from...
October 19, 2015 at 3:02 am
Firstly, AlwaysOn is a marketing term, not a feature. The two features are Always On Failover Clustering and Always On Availability Groups
I'm going to assume you mean Availability Groups, because...
October 19, 2015 at 2:49 am
First try run Management Studio as admin (right click shortcut, run as administrator)
If that doesn't work, then you need to grant the service account which SQL Express is running under...
October 19, 2015 at 2:47 am
happygeek (10/17/2015)
I think the tipping point was "I had a windows 7 laptop and the hard drive became faulty...." while following the debate on posted questions getting worse.
That particular thread...
October 18, 2015 at 6:27 am
happygeek (10/17/2015)
Should there be a limit to the number of postings or some other means of regulation?
Why?
The 5000 page thread (and there's only one of them) is a chat thread...
October 17, 2015 at 12:45 pm
Without knowing the structure of your database, it's kinda impossible to answer.
What is stored in the fName and filePath columns of the Employee table? Just the most recent upload?
Is there...
October 17, 2015 at 7:53 am
select object_name, * from epTracking_db.sys.indexes where object_id = 53575229 and index_id = 9
The table's called 'ep_ACTION_track_Archive_20150819'
October 16, 2015 at 7:52 am
The 'share with other machines on local network' option is awesome for me. I'll have two machines running Win 10 and one running Server 2012 R2. If I can save...
October 16, 2015 at 6:57 am
Please look in sys.indexes, identify which index has an ID of 9 on the table with an objectid of 53575229.
Drop that index and rerun the CheckDB.
October 16, 2015 at 6:55 am
Please run the following and post the full and complete output.
DBCC CheckDB ('<Database name>') WITH NO_INFOMSGS
Do you have a clean backup and a full set of log backups since that...
October 16, 2015 at 5:45 am
Same as in bulk logged and full recovery. Log records describing changes made to the database. The main difference with Simple recovery is how long the log records are retained,...
October 16, 2015 at 5:43 am
Viewing 15 posts - 4,471 through 4,485 (of 49,571 total)