Sunday, February 19, 2012

after taking backup , not able to see Databasename.Bak

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