Viewing 15 posts - 1,801 through 1,815 (of 4,745 total)
Thanks for the replies.
Brian, can you expand on that, do you mean they could run sp_delete_job? BOL does not seem to suggest that.
Elliot, this is a dev environment and the...
May 16, 2011 at 2:14 pm
you need an account with sysdmin to connect, then configure the security (using the roles in RS) via the URL http:\servername\reportserver
May 13, 2011 at 3:26 am
2008 and 2008R2 are different versions and therefore on different 'tracks'. so the SP2 for 2008 is not applicable to R2.
I would agree that if you are upgrading at this...
May 12, 2011 at 3:22 pm
our posts crossed pam, that was not explicit from your first post 🙂
alter database modify file is still the better way to move database files, which means offlining the database.
May 12, 2011 at 3:08 pm
if its in single user mode how do you know you will be the fist user to connect to the database?
rather than detach\attach use alter database modify file command. It...
May 12, 2011 at 2:02 pm
maybe you just have not transferred the logins?
If you have but created them on the secondary server the user and login now have different sids and the user is orphaned...
May 11, 2011 at 2:59 pm
you need to run dbcc shrinkfile. Try the truncateonly option first. If that gives you no space back specify a size less than 10GB but with which gives you reasonable...
May 11, 2011 at 5:44 am
are you running transaction log backups?
May 11, 2011 at 4:54 am
you can convert clustering from an HA solution to a true DR set up by:
setting it up as a geo-cluster (SAN replication and windows 2008 required)
log shipping to a third...
May 10, 2011 at 4:00 pm
you will have to write your own custom process but you can log ship to a higher version, You will have to leave the database in norecovery mode, the standby...
May 10, 2011 at 3:37 pm
you really should read this:
http://sqlskills.com/BLOGS/KIMBERLY/post/Transaction-Log-VLFs-too-many-or-too-few.aspx
May 10, 2011 at 3:27 pm
its asking for your windows account and password
May 10, 2011 at 3:20 pm
creating\dropping objects will be in the default trace.
some server configuration changes will be in the errorlog but not exactly sure which will or won't be.
If this is SQL2008 you could...
May 6, 2011 at 3:00 pm
Are you scripting out jobs created by maintenance plans?
I have come across an issue in 2008R2 RTM where if two jobs have steps with the same name it confuses the...
May 2, 2011 at 2:07 pm
Viewing 15 posts - 1,801 through 1,815 (of 4,745 total)