\Backup directories - remove safely?

I've successfully applied SP4 to an MSDE 2000 installation on a
Windows 2000 Professional system. Now I've notived several \Backup
subdirectories in the "Microsoft SLQ Server" directory. Since I don't
want to go back to any previous version, these subdirectories appear
to be no longer required. May I safely remove them?
Heinz Wehner
(Karlsruhe, Germany)
Hi,
No problems. You can delete that directory.
Thanks
Hari
SQL Server MVP
"Heinz Wehner" <hwehner@.hotmail.com> wrote in message
news:c215e1ppe9k9vqim24ckphf0eukkgr6n5a@.4ax.com...
> I've successfully applied SP4 to an MSDE 2000 installation on a
> Windows 2000 Professional system. Now I've notived several \Backup
> subdirectories in the "Microsoft SLQ Server" directory. Since I don't
> want to go back to any previous version, these subdirectories appear
> to be no longer required. May I safely remove them?
> Heinz Wehner
> (Karlsruhe, Germany)
|||Thanks Hari.

> On Sun, 24 Jul 2005 19:32:03 +0530,
> Hari Prasad <hari_prasad_k@.hotmail.com> wrote:
> Hi,
> No problems. You can delete that directory.
> Thanks
> Hari
> SQL Server MVP
>
> Heinz Wehner <hwehner@.hotmail.com>
> wrote in message news:c215e1ppe9k9vqim24ckphf0eukkgr6n5a@.4ax.com...
> I've successfully applied SP4 to an MSDE 2000 installation on a
> Windows 2000 Professional system. Now I've notived several \Backup
> subdirectories in the "Microsoft SLQ Server" directory. Since I don't
> want to go back to any previous version, these subdirectories appear
> to be no longer required. May I safely remove them?
> Heinz Wehner
> (Karlsruhe, Germany)
sql

[help] installation problems with sql server express 2005

hello everybody
I've downloaded a free version of ms sql server express 2005
and while I lauch the install file, I Have a bug :
Something like :
"you don't have write and read permission" - conctact administator
but i'm logged on a administator session

if anyone can help me ..
thnx in advance ..
hzben

Hi,

Ensure you have Read & Write permission on the folder/drive you are trying to install SQL Server , i.e. Program Files folder!!! www.windowsecurity.com/articles/Understanding-Windows-NTFS-Permissions.html FYI.

Hemantgiri S. Goswami

|||thank you for this reply
Do i can export a sql 2000 database to sql 2005 express only with a .sql file or do i need the .mdf and .ldf files of my old database ?
I need to export only the structure (tables ,columns and triggers) of my database to sql express 2005 .
have a nice day !!
hzben|||

Hi hzben,

you can export the structure of your database with your .sql file (Script of Database Objects) and for that you don't need .mdf/.ldf files. But in case you wants to attach your database to sql server you require .mdf and .ldf.

HTH

Hemantgiri S. Goswami

[Fail] Could not add ASPNET user to SQL Server.

Ok here's my setup

1. Installed msde 2000 with sp3.
2. started the SQL Server and SQL Server Agent.
3. Ran IBuySpy Store Installation, when I ran the configuration I get error on bottum.

10:51:55 PM Tuesday, September 23, 2003: [Checking system requirements]
10:51:55 PM Tuesday, September 23, 2003: [Pass] Detected a local instance of SQL Server.
10:51:55 PM Tuesday, September 23, 2003: [Pass] Determined SQL Server version (8.00.194).
10:51:55 PM Tuesday, September 23, 2003: [Pass] Detected .NET Framework.
10:51:55 PM Tuesday, September 23, 2003: [Pass] Detected Internet Information Server (IIS).
10:52:03 PM Tuesday, September 23, 2003: [Begin Sample Configuration]
10:52:05 PM Tuesday, September 23, 2003: [Pass] Created IIS virtual directory.: StoreVBVS
10:52:05 PM Tuesday, September 23, 2003: [Pass] Determined SQL Server version (8.00.194).
10:52:22 PM Tuesday, September 23, 2003: [Fail] Could not add ASPNET user to SQL Server.
SQL Server does not exist or access denied.
10:52:22 PM Tuesday, September 23, 2003: [Done]

Can someone please tell me step by step on what I need to do and where to do it to get this working, thanks !!!did you add it via users in your db? when you xpand our db in sql server xplorer, you can add users using "users"...

HTH