Hi..
I am triying to take full ,differential ,transactionlog backups...
For that i have created jobs...
I am able to create a job, run a job, it says success...
But not able to see the database.bak at the specified location...
I have admin rights on my local computer .. also admin rights on sql server2005...
can you tell me , where i am going wrong...
And if i take a back up by right clicking the database , i am abe to get the database.bak
Since this is apparently a question related strictly to SQL, I've moved it from the Team Foundation Server forum to one of the SQL forums.|||If you created a database maintenance plan, the filenames should be in this format: dbname_db_yyyymmddhhmm.bak for full database backup; for transaction log backups, they're in his format: dbname_tlog_yyyymmddhhmm.trn. Look for these files|||If you are doing a backup you are always doing a backup on the server not on the client you are connected with.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
No comments:
Post a Comment