Viewing 15 posts - 46 through 60 (of 296 total)
Did you change the service account w/o using CM? Make sure the path to which you are backing up, the service account has access to it.
July 9, 2009 at 5:43 am
I'd go with mirroring myself, but I'd supplement it with log shipping to recover from non-critical errors (like table deletes), maybe with a 2 hour delay on the restores.
Isn't...
July 8, 2009 at 9:44 am
Run this procedure for each database except master and tempdb. You can't revoke the guest permissions in both these databases.
SELECT dpr.name, dpr.type_desc, dpe.permission_name, dpe.state_desc
FROM sys.database_principals dpr LEFT JOIN sys.database_permissions dpe...
July 8, 2009 at 9:22 am
i have in the past done an index rebuild after a disk defrag especially since the disk defrag is done during a maintenance window and the index rebuilds are also...
July 8, 2009 at 9:04 am
OS level fragmentation usually occurs if your data files aren't sized correctly and have to keep growing to accomodate data growth. This is definitely not a new issue for SQL...
July 8, 2009 at 8:45 am
Using the COPY_ONLY option would cause that problem, however I didn't see that in the code.
July 7, 2009 at 9:53 am
You need to find out "Why backups need to be stored on local machines?"
Databases should be backed up and sent to an off-site location or a designated DR site and...
July 7, 2009 at 7:48 am
Are you looking for continuous data mirroring or one time snapshot availability for reporting purposes?
July 6, 2009 at 10:59 am
Robb (6/22/2009)
Suggestions on utilities or methods of copying .bak files to other locations?
I've used robocopy in the past to successfully and reliably copy backups over to remote sites.
July 1, 2009 at 11:53 am
Unfortunately, the backups will fail when the active node fails over to the passive node if the backup job is currently executing. You can have a job scheduled to monitor...
July 1, 2009 at 11:49 am
Its the same with our servers. Monthly patch weekend 🙂
July 1, 2009 at 6:41 am
What ever account type you decide to use, you should configure the services from Configuration Manager. CM grants the account all the necessary permissions on the OS and SQL.
July 1, 2009 at 6:37 am
From BOL...
The counters are initialized to empty whenever the SQL Server (MSSQLSERVER) service is started.
Dependening on when your services were last recycled this may not give you the right information.
June 30, 2009 at 6:47 am
Viewing 15 posts - 46 through 60 (of 296 total)