MS SQL Server 6.5 Exam

[Thomas Chea]

1.You use new database dialog to create DB, but there's not available
Device, what is your quickest way to create a new device.

2.-Data and log are on same device, you issue:

DUMP database mydb to dump1

DUMP transaction mydb with truncate_only

What happened to trans log?

3 -Setting up Windows client to access your server, you enter the IP address
of the PDC, would this work?

[Jose Pons]

1. Use DISK INIT, obviously with the client SQL Server
2. On the first you get a complete backup with the second you clean up the log
3. There are different parts, if you setup the protocol it doesn't mean that you are connect to the server, on the other side for SQL Server you need a ODBC, but for a LAN I am think that are OK.

By the way why an exam? Do I pass?

On 11/12/98 4:30:47 AM, Thomas Chea wrote:
> 1.You use new database dialog to create DB, but there's not
> available
Device, what is your quickest way to create a new device.
>

2.-Data and log are on same device, you issue:

DUMP database mydb
> to dump1

DUMP transaction mydb with truncate_only

What happened to
> trans log?

3 -Setting up Windows client to access your server, you
> enter the IP address
of the PDC, would this work?