Thanks I was just wondering about performance. However I am going to stick with varchar(1000) could even increase up a notch for good measures. Also...
I have a table were I would like to store a description in a column, I want to stay away from using Text datatype since it puts the column in its own...
So your saying to back up to local disk first, then back up from disk to Tape Drive? If so how often do I back up from local disk to tape drive? Why...
Since I included the WAITFOR DELAY '00:00:10' BACKUP DATABASE... statement all backups have succesfully completed without any retries. I dont know if...
I added the waitfor statement TO each job step as follows. WAITFOR DELAY '00:00:10' BACKUP DATABASE.... One thing I notice in the SQL Log was this...
Will do Thanks a lot for your help. By the way is there a way I can run a job just to format the disk and create a new media set? If not no problem....
I get a syntax error near the waitfor keyword with and without the comma. BACKUP LOG Corporativa TO [TapeBK_01] WAITFOR DELAY '00:00:05', WITH...
I guess that solves the problem. Thanks you guys. Thanks
The backups all succeed. When I read the history table i notice that it has to arbitrarly retry on a one the steps. I'm running a job that backs up 9...
just ran xp_loginconfig Here is the output .... audit levelfailure I had set this option from all to Failure this morning like you instructed. It...
I just checked the log it is about 370614 Bytes. I cycled it this morning and it still record all login activity. before I started cylcling it was...
Ok that must be the problem, I set up a Job to cycle the log each morning, so I'll just restart tonight. Thanks
last night I set the property to Failure and it still records Logins. Does this propery requiere to restart. Thanks
Thanks a lot before I used sp_cycleerrorlog the log was 14 gigs. It grows about a 1 gig every day with all the excess loging Thanks
In the error log is there a way that I can control what gets put into it. For example it records every time a user connection was issued. This log...
The first step in the job runs this command. It writes over any existing data on the tape which would be last weeks back up because I use a different...
I had read that today earlier but didnt really look into it. Thanks Thanks
I´ve been testing everything and it works find. Exept that everytime I run the job it fails in one of the steps (backups) I configured it so it will...
Let know if this plan will work. Db back up are every day every 6 hours from 9am - 9pm 9am 3pm 9pm Transaction log back ups are every day every 3...
Yes thanks. Thanks
Separate names with a comma.
