Viewing 15 posts - 121 through 135 (of 1,536 total)
Shodhan (2/16/2012)
Hi,You can create a script using the extended stored procedure "xp_fixeddrives" to check the space usage in each of the hard drives.
Regards,
Shodhan
Although that's not going to help you if...
February 16, 2012 at 2:11 pm
I would highly recommend searching the SSC scripts[/url]. There are multiple scripts which will do what you need.
February 14, 2012 at 12:50 pm
It looks like you are running SQL Server Agent as Network Service. RKO1\PRDSQL1$ is the machine account (that's why you don't see a login).
Either change SQL Agent to run as...
February 14, 2012 at 12:48 pm
It means that you have an I/O issue. This could be caused by a very small (or very large) growth setting on that particular log file and that it is...
February 13, 2012 at 11:46 am
I always go with creating the computer object in AD prior to doing anything with SQL installation. Then grant full control over that object to the cluster computer name. Eliminates...
February 13, 2012 at 10:39 am
Excellent.
Firewalls, they are great, but they can be a real pain too.
February 13, 2012 at 8:55 am
If SQL Server isn't listening on 1433 then there would be no firewall exception put in place for it.
UDP 1434 allows the browser service to tell the client what...
February 12, 2012 at 9:48 am
When creating a DSN and choosing Windows Authentication for your login id it will pass along the credentials of the account that you are logged in as. If that account...
February 12, 2012 at 8:35 am
It appears as though you are attempting to apply a 64bit version of the service pack on an x86 installation of SQL Server. Double check that you downloaded the correct...
February 12, 2012 at 7:21 am
Check to see if the account you are using for the DSN has permissions on SQL Server. You might also want to check the SQL Server error log to see...
February 12, 2012 at 7:19 am
If you were using network service then all would be good.
Really your only option is to use a proxy along with (I'd recommend) an SSIS package to back everything up.
February 12, 2012 at 7:15 am
Correct.
If you query sys.databases you'll see that the owner of the master, model, msdb and tempdb databases are already SA.
SELECT NAME, SUSER_SNAME(owner_sid) FROM sys.databases
February 10, 2012 at 4:35 pm
During the install you will be asked if you want to install Windows or Mixed Mode. If you go with mixed mode you have to specify an SA account to...
February 10, 2012 at 4:21 pm
A quick and brief search gives you the following link http://technet.microsoft.com/en-us/library/cc768048.aspx. That's a good place to start.
February 10, 2012 at 3:03 pm
Well to begin with you would have to define production down and the roles and responsibilities of the DBA in your company. Then in the event of production being down...
February 10, 2012 at 11:42 am
Viewing 15 posts - 121 through 135 (of 1,536 total)