Viewing 15 posts - 7,066 through 7,080 (of 9,253 total)
Jon Russell (6/9/2011)
I want a recent copy of our production SQL 2008 R2 database available for developers. Normally, I just...
June 9, 2011 at 2:51 pm
well, the error 2 indicates you may still be having those permissions errors. Whether the files are stored on a share on the primary, secondary or a file server the...
June 9, 2011 at 2:40 pm
check books online for differences between the two. Mirroring is a constant replication of the database, whereby log shipping is a set of scheduled operations consisting of a backup at...
June 9, 2011 at 2:37 pm
who set up the SSRS instance, get them to check which windows users have access via report manager. By default local administrators have full admin access
June 8, 2011 at 12:19 pm
operating system error 2 means the actual file specified cannot be found. Im guessing by the UNC path that you are backing to a local that is not local. Try...
June 8, 2011 at 12:16 pm
Jon.Morisi (6/7/2011)
Looks like my issue was a bad hosts file entry...check yours...
why on earth are you using hosts file entires and not your DNS zone??
June 8, 2011 at 12:09 pm
GSquared (6/2/2011)
but that will invoke the distributed transaction coordinator
not to mention all the NetBIOS port coms it requires
June 8, 2011 at 12:03 pm
GilaMonster (6/8/2011)
it's 0 times in 6 years.
wow, as often as that Gail 🙂
bopeavy (6/8/2011)
June 8, 2011 at 11:57 am
Perry Whittle (6/8/2011)
June 8, 2011 at 9:19 am
Although you have removed the file it cannot be truly dropped until you restart the database, as this is tempdb you must restart the SQL server services (no reboot required)
June 8, 2011 at 8:20 am
Perry Whittle (6/8/2011)
what command did you use to drop the files?
:Whistling:
June 8, 2011 at 7:56 am
what command did you use to drop the files?
June 8, 2011 at 7:11 am
rahulr.sharma (6/2/2011)
My motive here is to look for a means to change the Security domain groups that are used for the Clustering services, after the installation is performed.
These...
June 4, 2011 at 1:02 pm
When moving user databases you dont need to detach them at all.
Issue the alter database modify file statements which will set the new paths. Take each database offline in...
June 3, 2011 at 1:16 am
Typically you dump the trace file output into a SQL server table and then query against that
USE Mydb
GO
SELECT * INTO mytracetable
FROM fn_trace_gettable('c:\temp\mytrace.trc', default);
GO
June 1, 2011 at 1:20 am
Viewing 15 posts - 7,066 through 7,080 (of 9,253 total)