Viewing 15 posts - 61 through 75 (of 88 total)
I'm pretty sure you can change it in management studio by right clicking the server ---> select Properties --->select database settings
You then can select your database default locations.
April 15, 2009 at 2:52 pm
I don't think you should ever want to restore a production database unless you lost data that can not be recovered.
April 15, 2009 at 2:42 pm
Try something like this but add your named instance and maybe port number.
add key="reportservice.reportservice" value="http://servername/ReportServer/ReportService.asmx"/>
add key="reportservice.path" value="http://servername/ReportServer/"/>
March 18, 2009 at 12:00 pm
I use Idera Sql Diangnostics manager and it works well. You can go to Idera's website and download 15 day trial.
January 13, 2009 at 1:45 pm
The hardest part about automating your restore process is grabbing the latest backup file name from the location you are backing up to.
-- Get Backup location and filename...
January 13, 2009 at 1:25 pm
Where exactly are you getting the error? In the the reporting services configuration manager?
a couple things to check:
-possibly the data source connection string is wrong
-windows firewall may be enabled.
January 13, 2009 at 12:34 pm
I had the same issue and found that by killing the host process would resolve the issue.
select hostprocess from master..sysprocesses
where spid=
In my scenario litespeed was the culprit... I went...
November 12, 2008 at 11:36 am
I thank you very much for your reply. This may sound dumb but why is truncating/shrinking the log file a bad idea?
Without DB mirroring enabled when I...
October 13, 2008 at 4:02 pm
I guess that there is no other way to shrink the log files with mirroring enabled. I guess what I can do is setup a nightly job using scripts...
1.)...
October 13, 2008 at 9:30 am
At my company the production dba will do the infrastructure with help from the sys admins meaning they will rack, cable, partition the disks and install the OS. Then...
October 7, 2008 at 2:55 pm
Yes I backup the log file every 15 minutes.
October 7, 2008 at 2:35 pm
Where I work we have the 2 sets of DBA's
The production DBA's sit on the application team and they handle the production and QA servers.
The other set of DBA's sit...
October 7, 2008 at 11:11 am
Here is the link to download sp2
October 1, 2008 at 8:23 am
I did this before using DTS package that was simple to do except I forgot to copy the keys and indexes.
September 24, 2008 at 2:15 pm
Viewing 15 posts - 61 through 75 (of 88 total)