did something go wrong?

I did an upgrade of a site system, computers and servers from NT4 server and
workstation to Win2K server and XP workstations. I made a backup of the
datatbase (SQL7) and did a restore on the new PDC (SQL2K server). Did a
change DB owner and then preformed another backup from the PDC to move to the
BDC.
The first backup was 2.2gig in size but when I did the backup from the new
SQL2K DB the backup file was 5.5gig. does anyone know what I may have done
wrong.
Thanks,
Ed
Hi
Do a complete index rebuild and an update statistics.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"raider2" wrote:

> I did an upgrade of a site system, computers and servers from NT4 server and
> workstation to Win2K server and XP workstations. I made a backup of the
> datatbase (SQL7) and did a restore on the new PDC (SQL2K server). Did a
> change DB owner and then preformed another backup from the PDC to move to the
> BDC.
> The first backup was 2.2gig in size but when I did the backup from the new
> SQL2K DB the backup file was 5.5gig. does anyone know what I may have done
> wrong.
> Thanks,
> Ed
>

did something go wrong?

I did an upgrade of a site system, computers and servers from NT4 server and
workstation to Win2K server and XP workstations. I made a backup of the
datatbase (SQL7) and did a restore on the new PDC (SQL2K server). Did a
change DB owner and then preformed another backup from the PDC to move to th
e
BDC.
The first backup was 2.2gig in size but when I did the backup from the new
SQL2K DB the backup file was 5.5gig. does anyone know what I may have done
wrong.
Thanks,
EdHi
Do a complete index rebuild and an update statistics.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"raider2" wrote:

> I did an upgrade of a site system, computers and servers from NT4 server a
nd
> workstation to Win2K server and XP workstations. I made a backup of the
> datatbase (SQL7) and did a restore on the new PDC (SQL2K server). Did a
> change DB owner and then preformed another backup from the PDC to move to
the
> BDC.
> The first backup was 2.2gig in size but when I did the backup from the new
> SQL2K DB the backup file was 5.5gig. does anyone know what I may have done
> wrong.
> Thanks,
> Ed
>

did something go wrong?

I did an upgrade of a site system, computers and servers from NT4 server and
workstation to Win2K server and XP workstations. I made a backup of the
datatbase (SQL7) and did a restore on the new PDC (SQL2K server). Did a
change DB owner and then preformed another backup from the PDC to move to the
BDC.
The first backup was 2.2gig in size but when I did the backup from the new
SQL2K DB the backup file was 5.5gig. does anyone know what I may have done
wrong.
Thanks,
EdHi
Do a complete index rebuild and an update statistics.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"raider2" wrote:
> I did an upgrade of a site system, computers and servers from NT4 server and
> workstation to Win2K server and XP workstations. I made a backup of the
> datatbase (SQL7) and did a restore on the new PDC (SQL2K server). Did a
> change DB owner and then preformed another backup from the PDC to move to the
> BDC.
> The first backup was 2.2gig in size but when I did the backup from the new
> SQL2K DB the backup file was 5.5gig. does anyone know what I may have done
> wrong.
> Thanks,
> Ed
>

Develop multiusers applications with SQL Server Express

Can I develop applications with SQL Server Express that I have more than one user in several computers working with the same database on a server, or I can only develop applications with only one user with a local database with SQL Server Express?

SQL Server Express will support multiple users. To connect from other computers you must first enable "Local and remote connections" in the Surface Area configuration tool .

Karl

|||

You should also read the Blog entry at http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx. You may need to enable SQL Browser and create Excpetions in your Firewall to allow people to connect to your SQL Express server. It all depends on the configuration of your computer and how you want to connect.

Regards,
Mike Wachal
SQL Express