Viewing 15 posts - 1,111 through 1,125 (of 1,319 total)
As stated: "invalid drive specification". Has the share been removed or have permissions for OKS-MAR\Administrator to the share changed?
-- You can't be late until you show up.
May 29, 2008 at 1:30 pm
The creation of the DTS package has to be done manually and should be quite simple to do. It can be scheduled to run as often as you'd like, provided...
-- You can't be late until you show up.
May 29, 2008 at 8:01 am
You can setup alerts via enterprise manager. On the server, drop down to Management->SQL Server Agent and you'll see alerts. Right-click, select new alert and fill in the blanks (either...
-- You can't be late until you show up.
May 29, 2008 at 7:47 am
Or restored to the same server/same instance using a different database name....
-- You can't be late until you show up.
May 29, 2008 at 7:37 am
Here is a Googled link that may be helpful, discussing full text catalog (might help):
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1835635&SiteID=1
-- You can't be late until you show up.
May 29, 2008 at 7:35 am
Is there a lot of historical data in it that can be archived or simply deleted? I think you need to get a better handle on the application and make...
-- You can't be late until you show up.
May 29, 2008 at 7:28 am
Do you have backups? If not, I believe you may be out of luck. There are some third party tools that can retrieve deleted files from disk but I don't...
-- You can't be late until you show up.
May 29, 2008 at 7:18 am
I must admit I'm running SQL2K3, 32 bit but I think this will apply. Awe needs to be enabled, /PAE should be in your boot.ini file and the account running...
-- You can't be late until you show up.
May 28, 2008 at 8:56 am
You will have to update the table sysjobs in msdb. The field is originating_server and should reflect the new server name. I've done this in the past without issue.
Edit -...
-- You can't be late until you show up.
May 28, 2008 at 8:45 am
Mobasha is right. You can take your full backups at anytime with a minimal performance hit. If your database is set to a recovery mode of "Full", you'll also want...
-- You can't be late until you show up.
May 28, 2008 at 7:56 am
Sorry, missed the part about it running fine manually:blush:
Here is another link. Also, when I google the error, a lot of the hits point to the SQL7-SQL2K issue the Greg...
-- You can't be late until you show up.
May 27, 2008 at 10:16 am
madhusudhana.r (5/27/2008)
Error string: The system cannot find the file specified. Error source:
Obviously, the specified file is not on the server. Check the location, based on your DTS package, and...
-- You can't be late until you show up.
May 27, 2008 at 9:45 am
If you have a pre and post backup, couldn't you simply init during each backup (or am I missing something)? That would overlay the latest of each of these backups,...
-- You can't be late until you show up.
May 27, 2008 at 7:39 am
I've used the same setup for years and never had issues. Recommended, leave 1-1.5 GB for OS and let SQL have the rest, if this is a dedicated SQL server....
-- You can't be late until you show up.
May 23, 2008 at 10:26 am
Typically, rebuilds should be run when you can have exlcusive use of the database. It will impact the server performance, it will log to the transaction log, use tempdb and,...
-- You can't be late until you show up.
May 23, 2008 at 9:29 am
Viewing 15 posts - 1,111 through 1,125 (of 1,319 total)