Viewing 15 posts - 1 through 15 (of 67 total)
1. To clarify some points, the restore is from the local server drive. The drive is SAN storage connected via a 2GB fiber optic connection.
2. I had...
May 3, 2011 at 6:59 am
GSquared,
I happen to agree that this isn't practical. However, I am still tasked with seeing if it can be done.
Just to clarify the need. This is...
February 11, 2011 at 7:45 am
If the database already exists, you will need to first detach the current version before attaching the new files. In order to detach it, all current connections need to...
August 2, 2010 at 12:56 pm
Steve
I have used that method for years with much success. Lately I have been trying to implement the same functionality using service broker event processing. However, I've not...
August 2, 2010 at 12:55 pm
You got it right. Just copy the files to the server and than attach the database using sp_attach_db:
EXEC sp_attach_db @dbname = <databasename>,
@filename1 = <full...
August 2, 2010 at 12:36 pm
So far, the consensus is just what I thought. While there may be some advantages to executing scripts for managing backups, without a specific need not addressed by Maintenance...
July 28, 2010 at 7:30 am
Jack,
I absolutely believe in the "limit access" mindset. Unfortunately, the business users in my company do not, which is why I have the dilemma. The business side of...
August 20, 2009 at 7:56 am
When using a subquery in the select statement the subquery can only return a single value. One (or more) of your subqueries is returning more than one value. ...
August 19, 2009 at 9:10 pm
Normajean,
The error is a not very well documented error message. Best guess is that either an I\O bottleneck or CPU\Memory pressure caused a situation where queries were waiting to...
October 4, 2007 at 6:20 am
Number 10 reminded of a recently learned lesson. I came in one morning and one of our major applications wasn't working....users could not log in . Of course,...
October 3, 2007 at 12:20 pm
Microsoft SQL Server 2000
- 8.00.760 which is the version for SP3.
And I only read that article 10 or 15 times yesterday while fighting the...
September 19, 2007 at 8:36 am
Dim objMessage
Dim bodytext
'Variable to hold message body
bodytext = "This is some text." & vbcrlf & This is another line of text." & vbcrlf
Set objMessage = CreateObject("CDO.Message")
objMessage.To="recipient@mailbox.com"
'From does not have...
July 9, 2007 at 6:21 am
If you are interested in just SQL Server counters, you can query the sysperfinfo table. However, you will want to do a little research as some of the values in...
July 5, 2007 at 8:59 am
A much easier task would be to use Performance Monitor Alerts. An alert can be configured to check for any Perfmon Object ( include SQL Objects ) and execute an...
July 5, 2007 at 8:47 am
That will work with the given example. However, it is dependent on the length of the data after ' on ' begin constant. Should the format of your alert string...
July 5, 2007 at 8:40 am
Viewing 15 posts - 1 through 15 (of 67 total)