Viewing 8 posts - 1 through 9 (of 9 total)
are you using the SQL Agent to run the job. If yes use the query analyzer to tun the backup script.
also see if you backup folder might need the...
Thank you.
Aatish Patel
June 28, 2011 at 10:00 am
7Zip works fine but RedGate is the best
Thank you.
Aatish Patel
June 28, 2011 at 9:59 am
Study from some certifications.
Read books and browse blogs. Look for some intern program.
These are the best way to be a SQL DBA
Thank you.
Aatish Patel
June 28, 2011 at 6:45 am
I also personally recommend RedGate.
Thank you.
Aatish Patel
June 28, 2011 at 6:43 am
If you post the solutions others can get some help.
Thank you.
Aatish Patel
June 28, 2011 at 6:41 am
I would say backup up to the server you want to restore. This will restore a bit faster. But as said earlier this will can be done either way.
Thank you.
Aatish Patel
June 28, 2011 at 6:40 am
I would change the database recovery to simple or bulk logged.
Check if i have lot of space on the drives.
Thank you.
Aatish Patel
June 27, 2011 at 1:34 pm
Try DBCC CheckDB and see if that is working fine.
Thank you.
Aatish Patel
June 27, 2011 at 1:29 pm
Viewing 8 posts - 1 through 9 (of 9 total)