Viewing 15 posts - 31 through 45 (of 73 total)
Try to run the job from New query window using sp_start_job and track it .
R u scheduling and running the mentioned job or manually its executed .If manually...
June 13, 2009 at 5:08 am
If cost is not a contraint try using backup Software Like litespeed or legato which proves fruitful
June 13, 2009 at 4:53 am
Check out this link , u can come to conclusion - http://msdn.microsoft.com/en-us/library/bb510414.aspx
May 18, 2009 at 2:36 am
run sp_spaceused and return the results.
Also sp_helpdb - requested this to check maxsize,initial size and filegrowth if its in % change it to some 50 or 100 MB
March 21, 2009 at 2:29 am
In SQL server 2005 use sp_sendmail procedure
@copy_receipents = '' to add mails id in CC lsit
March 21, 2009 at 2:26 am
this example is for SQL server 2005
March 21, 2009 at 1:56 am
Post adding /3GB in boot.ini server needs to be rebooted
Then u have to decide how much u r planning to provide for SQL server
For example : Total physical...
March 21, 2009 at 1:54 am
Just to add few more point , Export and Import wizard will copy only data apart from SPs, Functions . index , .triggers all needs to be scripted and created...
March 21, 2009 at 1:44 am
First reason if there is no disk space - so careful palnning of backup strategy will help , Full , differential and transaction log backups and then moving it to...
March 21, 2009 at 1:41 am
First plz clarify whether the server is moved to different domain and secondly check whether the maintenance plan still exists
March 21, 2009 at 1:34 am
Some possible problems.
1.Tape backup my be blocking the file from deletion .
2.Also check SQL server startup account has modify permission for respective folders and file level too
3....
March 21, 2009 at 1:31 am
Its advisable to set Auto file growth is in MB rather than in % for better performance , so if u keep as 100MB which is 10% of the 1GB...
March 4, 2009 at 1:51 pm
Viewing 15 posts - 31 through 45 (of 73 total)