t-sql backup and restore

I need to restore 1 database from another database on a schedule once a week.  How can I do this with either a management plan in Microsoft SQL server 2005 management studio or with t-sql commands?  The main concern is that both databases use more than one data file and are named differently.  How do I make sure the restore goes to data files with the correct database name?

database script?

Wanna be a little more specific?

>>3
figure out how to export or generate an sql script from your database.
google is your friend

I'm aware of how to do this.  The script it generates doesnt seem to take filenames into account.

if(suck.dicks.dicks.dicks.dicks.dicks.dicks.dicks.dicks.dicks.dicks.dicks.dicks.dicks.dicks.dicks.dicks.dicks) throw new NullPointerException();
Exception in thread "main" java.lang.NullPointerException at dicks.java(dicks.java:1)

Could you at least troll in the correct language?

>>6
>throw new NullPointerException
Reactionface.jpeg

public static Object nullCoalesce(Object o1, String property) {

>>8
back to /g/ please

Are you GAY?
Are you a NIGGER?
Are you a GAY NIGGER?

If you answered "Yes" to all of the above questions, then GNAA (GAY NIGGER ASSOCIATION OF AMERICA) might be exactly what you've been looking for!

Don't change these.

Name:		Email:
Entire Thread Thread List