Viewing 15 posts - 2,746 through 2,760 (of 6,679 total)
SQLRNNR (3/27/2013)
Maint plans have a lot of shortcomings. This happens to be one of them. Many DBAs use script based...
March 28, 2013 at 12:34 pm
SQLKnowItAll (3/22/2013)
Our SE team takes snapshots/images of the server itself for this purpose. Although, we store our SSIS packages in MSDB, so those are protected by MSDB backups.
I would be...
March 25, 2013 at 11:30 am
Talk to your SAN team and vendor - they may have better solutions for producing replicas that you can use for your situation.
Also, you may want to investigate upgrading to...
March 21, 2013 at 12:31 pm
Dynamic SQL is the better choice in this case - however, the way you have approached this has created a potential issue and opened that procedure up to SQL injection.
You...
March 20, 2013 at 2:43 pm
Denise McMillan (3/18/2013)
\\servername\d$\foldername\filename.txt
Thanks to everyone for taking the time to help me with...
March 18, 2013 at 3:54 pm
Make sure the SQL Server service account has access to the share. If your agent job is running as a sysadmin user it actually runs in the context of...
March 18, 2013 at 11:54 am
You really don't want to be building your searches this way. What happens when you change from a datetime data type to a datetime2 data type?
You will then be...
March 18, 2013 at 11:37 am
When you installed SQL Server 2008 - did you install with the default Service SID?
If so, then your domain account running SQL Server agent does not have access to SQL...
March 13, 2013 at 12:39 pm
What is the error you are getting?
I am going to guess that you are getting an error similar to SSPI cannot generate context. If so, then your problem is...
March 13, 2013 at 12:33 pm
A couple of points:
Verify that the version of your client tools are the same or greater than the version of SQL Server you are connecting to. These kinds of...
March 13, 2013 at 12:30 pm
Since you are going to restore the database anyways - this will work:
ALTER DATABASE {database} SET OFFLINE WITH ROLLBACK IMMEDIATE;
Take the database offline, perform your restore - and the database...
March 8, 2013 at 11:39 am
Litespeed does not store anything additional over what is stored by native backups in msdb.
With that said, Litespeed can be configured to stored history in a repository which is either...
March 7, 2013 at 12:07 pm
Check for an active transaction in the other databases - especially tempdb.
February 8, 2013 at 1:16 pm
sdpages (2/7/2013)
I'm doing REBUILDs . I'm on Enterprise 2008 R2.Cannot do ONLINE=ON . We have BLOBs datatypes.
Unless your non-clustered indexes actually include the LOB columns, they can...
February 7, 2013 at 1:22 pm
Viewing 15 posts - 2,746 through 2,760 (of 6,679 total)