Full Sql Server Backup

Hi,
I'm trying to make a Full backup of my Sql Server. I use Tivoli Storage
Manager for my backups. First i do a full backup of my files on the server,
then i use an Agent to create a backup of the databases. My backup works
fine. But when i do a restore i can't start my MSSQLSERVER services because
my database Master isn't there, and i can't restore my db Master because
MSSQLSERVER isn't running.
I got a few errors before that, but it was the folder name that was changed
to 8.3 naming in the registry, i fixed it.
Anyone have an idea how a can do a full backup of my server so that i can
restore it completly to a new server?
ThanksStop SQL Services and perform file backup. Restore file backups with sql
services on new server stopped. Clean up.
"Phil" wrote:
> Hi,
> I'm trying to make a Full backup of my Sql Server. I use Tivoli Storage
> Manager for my backups. First i do a full backup of my files on the server,
> then i use an Agent to create a backup of the databases. My backup works
> fine. But when i do a restore i can't start my MSSQLSERVER services because
> my database Master isn't there, and i can't restore my db Master because
> MSSQLSERVER isn't running.
> I got a few errors before that, but it was the folder name that was changed
> to 8.3 naming in the registry, i fixed it.
> Anyone have an idea how a can do a full backup of my server so that i can
> restore it completly to a new server?
> Thanks|||Ok that's on solution, but is there a way to do it without stopping the
services?
"Jeffrey K. Ericson" wrote:
> Stop SQL Services and perform file backup. Restore file backups with sql
> services on new server stopped. Clean up.
> "Phil" wrote:
> > Hi,
> >
> > I'm trying to make a Full backup of my Sql Server. I use Tivoli Storage
> > Manager for my backups. First i do a full backup of my files on the server,
> > then i use an Agent to create a backup of the databases. My backup works
> > fine. But when i do a restore i can't start my MSSQLSERVER services because
> > my database Master isn't there, and i can't restore my db Master because
> > MSSQLSERVER isn't running.
> > I got a few errors before that, but it was the folder name that was changed
> > to 8.3 naming in the registry, i fixed it.
> > Anyone have an idea how a can do a full backup of my server so that i can
> > restore it completly to a new server?
> >
> > Thanks|||Hi
That is not a supported way of backing up and restoring a SQL Server
installation.
You must backup your databases to disk via the backup command in SQL Server.
Thne backup the resulatnt backup files to tape.
On the other SQL Server, restore the backups using the restore command.
To restore master, you must follow "Restoring the master Database from a
Current Backup" in books online.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Phil" <Phil@.discussions.microsoft.com> wrote in message
news:69E8A7C7-CDA0-4A1B-9863-74C23B855133@.microsoft.com...
> Ok that's on solution, but is there a way to do it without stopping the
> services?
>
> "Jeffrey K. Ericson" wrote:
>> Stop SQL Services and perform file backup. Restore file backups with sql
>> services on new server stopped. Clean up.
>> "Phil" wrote:
>> > Hi,
>> >
>> > I'm trying to make a Full backup of my Sql Server. I use Tivoli Storage
>> > Manager for my backups. First i do a full backup of my files on the
>> > server,
>> > then i use an Agent to create a backup of the databases. My backup
>> > works
>> > fine. But when i do a restore i can't start my MSSQLSERVER services
>> > because
>> > my database Master isn't there, and i can't restore my db Master
>> > because
>> > MSSQLSERVER isn't running.
>> > I got a few errors before that, but it was the folder name that was
>> > changed
>> > to 8.3 naming in the registry, i fixed it.
>> > Anyone have an idea how a can do a full backup of my server so that i
>> > can
>> > restore it completly to a new server?
>> >
>> > Thanks|||Ok what your telling me is that it's impossible to do a full backup a my SQL
server, and a backup of the database, and to restore to a new server(with
nothing on)?
Is that correct?
I would need to backup my DBs, then install a new SQL Server and then
restore my DB's?
Thanks
Philip
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> That is not a supported way of backing up and restoring a SQL Server
> installation.
> You must backup your databases to disk via the backup command in SQL Server.
> Thne backup the resulatnt backup files to tape.
> On the other SQL Server, restore the backups using the restore command.
> To restore master, you must follow "Restoring the master Database from a
> Current Backup" in books online.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Phil" <Phil@.discussions.microsoft.com> wrote in message
> news:69E8A7C7-CDA0-4A1B-9863-74C23B855133@.microsoft.com...
> > Ok that's on solution, but is there a way to do it without stopping the
> > services?
> >
> >
> > "Jeffrey K. Ericson" wrote:
> >
> >> Stop SQL Services and perform file backup. Restore file backups with sql
> >> services on new server stopped. Clean up.
> >>
> >> "Phil" wrote:
> >>
> >> > Hi,
> >> >
> >> > I'm trying to make a Full backup of my Sql Server. I use Tivoli Storage
> >> > Manager for my backups. First i do a full backup of my files on the
> >> > server,
> >> > then i use an Agent to create a backup of the databases. My backup
> >> > works
> >> > fine. But when i do a restore i can't start my MSSQLSERVER services
> >> > because
> >> > my database Master isn't there, and i can't restore my db Master
> >> > because
> >> > MSSQLSERVER isn't running.
> >> > I got a few errors before that, but it was the folder name that was
> >> > changed
> >> > to 8.3 naming in the registry, i fixed it.
> >> > Anyone have an idea how a can do a full backup of my server so that i
> >> > can
> >> > restore it completly to a new server?
> >> >
> >> > Thanks
>
>