COOL_ICE (9/7/2010)

---

Hi Ratheesh,

On which version of SQL server did you test this? In SQL 2008 you can not save sa password and MS has confirmed it as bug and they...

Hi Samji,

Please dont post wrong information..SQL server Allows to save password for SA login by checking that option.

COOL_ICE,

U sure that u can delete an SQL login from SQL Server 2008??

Try searching with keyword .mdf

Thanks Gail 😀

Check using RESTORE HEADERONLY & RESTORE LABEL ONLY...

Posting the exact error will help you

Sure Gail Thanks 🙂

Is it possible to restore using a backup having both primary & secondary filegroup backup??

I tried restoring backup of primary filegroup alone but its giving error that other files are...

You can check this

http://www.sqlteam.com/article/scheduling-jobs-in-sql-server-express

After that how he will restore??

Excellent catch Ananth..

Will wait for his explanation 🙂

Connect to sql server in single user mode..

net start mssqlserver /c /m /t3604

sqlcmd -E

create a new sql login and give SA right

Hope this might help

Hi Bill,

Filestream is a server level configuration and you cant enable that using ALTER Database..

Wayne said it...Thats the way you can schedule the SP in Agent job and give the second SP as second step..

If you dont have permission to run the job ask...

Go to SQL Server configuration manager-->right click server service-->properties-->filestream tab-->enable

EXEC sp_configure filestream_access_level, 2

RECONFIGURE

You can also try server properties-->advaced--Filestream access level..but this seems to be not changing even after changing under...