Re: moving data in a database to another file on a SAN

From: Dan D. (DanD_at_discussions.microsoft.com)
Date: 06/21/04 

Date: Mon, 21 Jun 2004 12:01:01 -0700

Thanks. 

-- 
Dan D.
"Andrew J. Kelly" wrote:
> No you can't remove the primary file.  You can create a clustered index on
> another filegroup and it will move the data but that is not what you want.
> Take a look at these.
> 
> 
> http://www.support.microsoft.com/?id=314546     Moving DB's between Servers
> http://www.support.microsoft.com/?id=224071     Moving SQL Server Databases
> to a New Location with Detach/Attach
> http://support.microsoft.com/?id=221465             Using WITH MOVE in a
> Restore
> http://www.databasejournal.com/features/mssql/article.php/2228611
> Transferring Logins
> http://www.support.microsoft.com/?id=246133     How To Transfer Logins and
> Passwords Between SQL Servers
> http://www.support.microsoft.com/?id=298897    Mapping Logins & SIDs after a
> Restore
> http://www.dbmaint.com/SyncSqlLogins.asp         Utility to map logins to
> users
> http://www.support.microsoft.com/?id=168001     User Logon and/or Permission
> Errors After Restoring Dump
> http://www.support.microsoft.com/?id=240872    How to Resolve Permission
> Issues When a Database Is Moved Between SQL Servers
> http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
> Restoring a .mdf
> http://www.support.microsoft.com/?id=307775    Disaster Recovery Articles
> for SQL Server
> 
> 
> -- 
> Andrew J. Kelly  SQL MVP
> 
> 
> "Dan D." <DanD@discussions.microsoft.com> wrote in message
> news:B05C208A-02B3-4F48-B349-082F3A78C1AB@microsoft.com...
> > We're moving data to a SAN. I seem to remember that there is a way to move
> data from the file that stores the data for a database to another file and
> then delete the original file. I thought that might work for moving the data
> to a SAN.
> >
> > I went to database properties and the data files tab and created a second
> file on the SAN. But I don't see how to get the data to move from the first
> file to the new file.
> >
> > Can someone tell me how to do this?
> >
> > Thanks,
> > -- 
> > Dan D.
> 
> 
>

Relevant Pages

  • Re: unable to start SQL Service ... error code 3417
    ... How about just create a new instance and restore databases to the new instance? ... I wouldn't go with restoring master from another instance. ... The supported route is to rebuild your master database, start SQL Server in single user mode, ...
    (microsoft.public.sqlserver.server)
  • Re: SQL 2000 SP4 on 2003 Server - Single User Mode
    ... I found the section where you list the filename to restore to. ... rename the SQL Server the same as what is listed below Courthouse? ... Once you've created your database (simply right click on the Database ...
    (microsoft.public.sqlserver.setup)
  • Re: Moving databases from SQL 7 to SQL 2000 - More Questions!
    ... want to run sp_updatestats after the restore or attach as well. ... >>There is a lot more that can go wrong with the wizard ... > SQL Server Databases ... >>Issues When a Database Is Moved Between SQL Servers ...
    (microsoft.public.sqlserver.setup)
  • Re: HELP!!! restore database - left in loading state?? PLEASE H
    ... RESTORE DATABASE WITH RECOVERY ... Columnist, SQL Server Professional ...
    (microsoft.public.sqlserver.tools)
  • Re: Restore Master DB to New Server
    ... the user database will be suspect. ... Just drop them and then do the restore. ... Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.tools)
Loading