Viewing 15 posts - 7,051 through 7,065 (of 9,244 total)
you dont seem to have made any provision for scenarios when a database name is passed in that is in Simple recovery mode
June 21, 2011 at 7:07 am
george sibbald (6/20/2011)
You can restart a log chain by issuing a differential backup,
indeed, see Paul Randalls article at this link
June 21, 2011 at 7:01 am
Shinoj Ramanathan (6/20/2011)
OS - 32bit Windows 2003R2
Physical Mem - 64 GB
SQL Server - 2005 SP2
AWE Enabled
Error...
June 21, 2011 at 6:50 am
please supply more details of the iSCSI setup, hardware or software?
June 21, 2011 at 5:52 am
forsqlserver (6/17/2011)
Thanks.0. The Whole storage is provided from the Netapp.Even OS drive C: also.
is this SQL Server a virtual machine?
forsqlserver (6/17/2011)
IsDomainNetworkTopOfBindings
Checks to see if the computer...
June 21, 2011 at 5:45 am
Hmm the server sprawl you describe would indicate that there aren't any change management policies or capacity management reviews in place.
I'm a big fan of virtualisation but your vendors...
June 16, 2011 at 1:20 am
Lee
Tally table is commonly used for iteration and replacing a loop. Jeff Moden explains more here[/URL]
June 13, 2011 at 5:11 pm
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
Viewing 15 posts - 7,051 through 7,065 (of 9,244 total)