PASS Virtual Summit

PASS is organizing virtual summit starting from Feb 10th 2010. The below are the streams in which its going to happen

Application Development

Business Intelligence

Database Administration

Performance

Professional Development

Virtualization

Women in Technology

Its worth giving a try as you will be discussing with experts across the globe. The only catch here is that all the chapters are going to happen only around noon mountain time, which will be last night for DBAs across Asia Pac. Atleast next time they should consider us while organising these events. You can get more info in the following link.

Interesting Bug with dbcreator role

With a user with dbcreator role when you try to backup or restore the database using GUI you will get the below error.

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup
Cannot access the specified path or file on the server. Verify that you have the necessary security privileges and that the path or file exists.

If you know that the service account can access a specific file, type in the full path for the file in the File Name control in the Locate dialog box.


Looks like a bug as specified here . The work around is also provided there which is to restore using scripts.