Check your database option 'auto close' is enabled or not.

When set to ON, the database is closed and shut down cleanly when the last user of the database exits...

Thanks. It works now.

Have you configured Secured Access Database as a Linked Server?

Edited by - Allen_Cui on 10/24/2002 08:51:30 AM

use yourdatabase

go

exec sp_spaceused @updateusage = 'TRUE'

go

dbcc sqlperf(logspace)

go

Edited by - Allen_Cui on 10/24/2002 08:08:11 AM

It is a secured Access database. Your procedure just doesn't work.

Try to use the UNC path. Make sure your SQL Server service a/c is able to access the network shared folders.

For example, Backup database pubs to disk = '\\remoteservername\sharedfoldername\pubs.bak'

Make sure the login you used to login into NT/2000 has been granted to access SQL Server.

Have you recently reonfigured your SQL Server with 'Force Protocol Encryption' being turned off/on? The error message seems indicate that a client try to access SQL Server with requests encryption,...

We have been running SQL Server in data center and database in Compaq SAN for two years. Initialiy, There were some problems in SAN and mostly related to the hardware,...

I don't understand your new question. Can you post script?

Use sp_help_job, you will be able to see the job status.

How do you perform the restoration? Can you post the restoration script and the error messages from SQL Server errorlog?

Try "exec xp_cmdshell 'dir q:\'" (change q to NAS drive letter)...

Use sp_change_users_login. See BOL for details.

SQL Server job can't be scheduled in seconds and that is why the job has to be scheduled in every one minutes in order to meet your request. In the...

Read Microsoft KB at http://support.microsoft.com/default.aspx?scid=kb;en-us;Q256650.

What about sp_pkeys.

How much spaces on the NAS do you see from the machine which SQL Server installed by using Windows explorer?