Viewing 15 posts - 76 through 90 (of 284 total)
You might want to perform a backup of the databases before it gets shut down, especially if there are going to be changes being done on the database servers or...
March 31, 2011 at 4:45 pm
I'm not sure how you can audit failed logins for Analysis Services but for the problem you are getting it may be worthwhile trying to connect to the cube as...
March 31, 2011 at 1:39 am
By default nobody will have access to the Reporting Services site other than an administrator. You'll have to add the users to the site by going into the root...
March 31, 2011 at 1:04 am
It really sounds like your backup file is corrupted and won't be able to be restored. Have you tried a restore verifyonly? Also, is a checkdb against the...
March 28, 2011 at 5:17 pm
Have you looked at mirroring? It could be used to keep the user databases on the DR server up to date rather than having to manually restore each database....
March 26, 2011 at 6:30 am
Schemas can't have a separate data file but object in the schema can be put on different filegroups which in turn can be put on different drives.
If you've checked sys.master_files...
March 26, 2011 at 6:16 am
You're right, SQL Server Reporting Services 2008 does not use IIS and in fact there can be issues with having IIS and RS 2008 on the same server.
http://technet.microsoft.com/en-us/library/bb630449(SQL.100).aspx
March 26, 2011 at 5:53 am
Good question. There have been a few Visual Studio questions recently - it's made me want to find out more about it as it could be quite useful. Thanks!
March 17, 2011 at 1:46 am
I think you will have to add a small SAN disk. Although it is a one node cluster, it is still a cluster and has requirements for the disk...
March 11, 2011 at 10:40 am
On a cluster all of the database files have to go on a cluster disk so that they can move between nodes in the event of a failover.
The...
March 11, 2011 at 1:09 am
You shouldn't really need to shrink your transaction log files; the database has worked hard to make them the size they are to accommodate the work that is being done...
February 26, 2011 at 4:08 am
Yes, the two instances are independent and so can have the same names for the linked servers
February 13, 2011 at 4:19 pm
Do you get the prompt when accessing the report page locally on the server? If so, do you get it when going to http:\\localhost\reports as well as http:\\<servername>\reports...
November 3, 2010 at 3:41 pm
find the SQL Agent job for this, go to Steps and edit the step - on the Advanced area, enter an output file and click on Include step output in...
November 2, 2010 at 9:30 am
There's a document here that shows how the two databases compare from a DBA point of view:
It's not so bad working with both once you work out how to do...
November 1, 2010 at 5:46 pm
Viewing 15 posts - 76 through 90 (of 284 total)