I would agree with John. You need to take backup of the database to separate files each time. Currently, you are taking backup in a single file which means it...

Pls run the following command and see if backup runs successfully.

backup database yourdb to disk='D:\payrbkp\yourdb.bak'

Difficult to get into a specific field when you are a fresher. Which city are you in?

:w00t:

Not a great advice that i would follow before knowing what exactly caused this.

did u try to backup the database from SSMS?

In SSMS, Your server > Management > SQL Server Logs.

There you will find various error log files. pls look out for error messages in the log files. Also see application...

Database has been detached so log file wont be available.

2)Create a new...

What Henrico suggested is you should map the shared folder to a drive letter.

right click my computer and click on map network drive. select a drive letter and enter the...

A suspect database should never have been detached!! you can try doing what was suggested in previous post. do you have backups?

you can submit the script in the scripts section so that it is easier to find out later on this forum.

It should be close to used space in the data file plus little more (some portion from active log file).

Looks nice. however it wont script object level permissions.

http://www.sql-server-performance.com/articles/dba/object_permission_scripts_p1.aspx

i used this script few days back. this scripts permissions for a single user. you might need to wrap the code in a loop or cursor to extract data for...

You have already gone through the places where i would have gone to search for that answer:-P. I would probably do what Kimberly says. like shrinking it for once and...

http://www.sqlskills.com/BLOGS/PAUL/category/Misconceptions.aspx

download the pdf from there and read point number 12/30

you cant have more authentic answer.