Viewing 15 posts - 46 through 60 (of 97 total)
Have you initialized the replication and generated the snapshot?
Snapshot replication runs on a schedule.
what schedule have you set?
What is the state of replication you look in replication monitor?
What do the...
November 6, 2015 at 4:10 am
Sorry, I meant ask to change it to 120 on your test server?
You say you installed 2014 on your test server and have restored the DB from LIVE to test...
November 3, 2015 at 7:06 am
The table(s) you purged all the data from, wouldn't it help if you dropped and recreated the clustered index(es)?
That way you are resizing the actual tables you purged and the...
November 3, 2015 at 6:46 am
Welcome 🙂
Try changing the compatibility mode to 120 and see if it complains about anything?
November 3, 2015 at 6:33 am
GilaMonster (10/28/2015)
.
hahahaha!!!
You just made my day 🙂
October 29, 2015 at 1:16 am
GilaMonster (10/16/2015)
Justin Manning SA (10/16/2015)
GilaMonster (10/16/2015)
Justin Manning SA (10/16/2015)
Isn't the rule of thumb for a Virtual Memory/Page file to be set to 1.5 x amount RAM?
It was, about...
October 16, 2015 at 3:24 am
GilaMonster (10/16/2015)
Justin Manning SA (10/16/2015)
Isn't the rule of thumb for a Virtual Memory/Page file to be set to 1.5 x amount RAM?It was, about 10 years ago....
Oh? But is...
October 16, 2015 at 3:02 am
Isn't the rule of thumb for a Virtual Memory/Page file to be set to 1.5 x amount RAM?
October 16, 2015 at 2:32 am
-- The following resulted in the following error message:
DBCC CHECKDB (ObfuscatedName);
/*
Msg 945, Level 14, State 2, Line 18
Database 'ObfuscatedName' cannot be opened due to inaccessible files or insufficient memory or...
October 13, 2015 at 5:46 am
Have you tried importing via linked server?
October 12, 2015 at 4:22 am
Are you backing up the database log frequently in your maintenance plan? How often do you back it up?
Sounds like you have a high volume of transactions, causing the log...
September 11, 2015 at 1:45 am
Stop your SQL Services
open a cmd window and run the following
sqlservr.exe -m -s GMSTDB2
open a new cmd window:
SQLCMD -s GMSTDB2
GO
RESTORE DATABASE master FROM 'Location of backup' WITH REPLACE
GO
Once the restore...
September 10, 2015 at 6:58 am
The sp that is local to the db will run first. If you want to run the sp in master, when you are in the context of myDB, you will...
September 1, 2015 at 1:30 am
Rather be safe than sorry and check all db's when you have a chance
August 20, 2015 at 1:42 am
Check if you have SQL Policy Management running , it may be a policy set to enforce instead of evaluate the setting?
July 28, 2015 at 9:44 am
Viewing 15 posts - 46 through 60 (of 97 total)