Post reply

What does the SQL Backup Files (.bak) Contains

  • May 3, 2006 at 6:32 am

    #172313

    Does the SQL Server .bak files contain just table data only? Or data and db scripts/structure? Or data, db scripts/structure, stored procedures, views, etc.? Can a .bak file be used to restore a db which does not already exists on a SQL Server? We have SQL Server 2000 Standard Edition (sp3) running on Windows 2003 EE.

    Thanks in advance, Kevin

  • May 3, 2006 at 6:49 am

    #635567

    The backup file contains everything in the database , it does not contain the logins

    Yes it can be restored onto another sql server , script out the login , jobs and dts's to execute on the other server

     

    regards

    wayne

  • May 3, 2006 at 8:19 am

    #635637

    This question is for Wayne Y, as you said, script out the logins!

    I don't know how can you script particular database users? If he is moving (restoring) only one db to another server, then he has to move users and not logins. If he is moving all the db's from one server to another server then probably he needs the logins script. And I dont know is there any way to take Database users by scripting?

    Thanks-Mubeen

  • May 3, 2006 at 8:48 am

    #635659

    If you need to copy logins and passwords to another SQL Server (or just make a backup of them), Microsoft has a great script for it.

    http://support.microsoft.com/default.aspx?scid=kb;en-us;246133

    -SQLBill

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply