Datacenter move.. Plan for SQL Servers

We will be moving to a new datacenter and wondering if there was any article
out there to help me get started on the planning required..
Thanks
This should be no difference than planning to move an instance/database to
another server, assuming you are going to a new server in the new datacenter.
Linchi
"Hassan" wrote:

> We will be moving to a new datacenter and wondering if there was any article
> out there to help me get started on the planning required..
> Thanks
>
>
|||Take a look into the article:-
http://www.forsythe.com/infrastrat&man/dcr/documents/MovingTheDataCenter.pdf
http://www.shunra.com/articles.aspx?articleId=10
Thanks
Hari
"Hassan" <Hassan@.hotmail.com> wrote in message
news:%23CTPtSgOHHA.4484@.TK2MSFTNGP02.phx.gbl...
> We will be moving to a new datacenter and wondering if there was any
> article out there to help me get started on the planning required..
> Thanks
>

Datacenter move.. Plan for SQL Servers

We will be moving to a new datacenter and wondering if there was any article
out there to help me get started on the planning required..
ThanksThis should be no difference than planning to move an instance/database to
another server, assuming you are going to a new server in the new datacenter.
Linchi
"Hassan" wrote:
> We will be moving to a new datacenter and wondering if there was any article
> out there to help me get started on the planning required..
> Thanks
>
>|||Take a look into the article:-
http://www.forsythe.com/infrastrat&man/dcr/documents/MovingTheDataCenter.pdf
http://www.shunra.com/articles.aspx?articleId=10
Thanks
Hari
"Hassan" <Hassan@.hotmail.com> wrote in message
news:%23CTPtSgOHHA.4484@.TK2MSFTNGP02.phx.gbl...
> We will be moving to a new datacenter and wondering if there was any
> article out there to help me get started on the planning required..
> Thanks
>

Datacenter move.. Plan for SQL Servers

We will be moving to a new datacenter and wondering if there was any article
out there to help me get started on the planning required..
ThanksThis should be no difference than planning to move an instance/database to
another server, assuming you are going to a new server in the new datacenter
.
Linchi
"Hassan" wrote:

> We will be moving to a new datacenter and wondering if there was any artic
le
> out there to help me get started on the planning required..
> Thanks
>
>|||Take a look into the article:-
http://www.forsythe.com/infrastrat&...eDataCenter.pdf
http://www.shunra.com/articles.aspx?articleId=10
Thanks
Hari
"Hassan" <Hassan@.hotmail.com> wrote in message
news:%23CTPtSgOHHA.4484@.TK2MSFTNGP02.phx.gbl...
> We will be moving to a new datacenter and wondering if there was any
> article out there to help me get started on the planning required..
> Thanks
>

Databases missing from Backup Task of Maintenance Plan

I'm moving databases from SQL7 to another server with SQL2005.

I have created new databases in SQL2005 via a restore from backup files created in the old server. Now I want to back up these new databases but they don't show in the Backup Task of a new or existing Maintenance Plan in Management Studio. I can backup them manually though. Any ideas?

I assume you have restored this database to a local 2005 server. If this is the case, they should show up. Maintenance plans can not make connections to SQL 7. Can you see this database via Management Studio?|||

Rob,

Yes, that's correct. I restored the databases to another server running SQL2005. None of the databases show up in any task of Management Studio's Maintenance Plans (eg Backup, Shrink, ReOrg)

-Bill

|||

Found the problem - the compatibility level was set to SQL Server 7.0 by default ( under database properties->options). As soon as I changed the compatiblity level to SQL Server 2000, the databases showed up in the Maintenance Plan tasks.

Thank you for your responses.

Databases

I have been assigned the task of DBA for our company's
payroll system running on SQL server 2k. My question is
this - In the maintenance plan, database backups,
transaction backups, etc...under properties it is backing
up 'master', everything is fine. However, our database
is 'WFT' shouldn't the database be set to WFT instead
of 'master'? Or does master contain all databases? I just
want to be sure we are getting the proper backup. Also
the job has the No Truncate command which causes the
event 17055. Can this command be omitted and everything
still be OK?
Thanks in advance.
DarrylThe link here should help you
http://msdn.microsoft.com/library/d...>
_03_378k.asp
I suggest making 2 maintenance plans. I would do one for your System
Databases and select All System Databases in the wizard. Then do another
for All User Databases. For Backups I also have the wizard put all backups
in their own subdirectories. This makes viewing easier and you can easily
see what is going on.
Jeff Duncan
MCDBA, MCSE+I
"Darryl" <anonymous@.discussions.microsoft.com> wrote in message
news:824801c431db$326c6560$a001280a@.phx.gbl...
> I have been assigned the task of DBA for our company's
> payroll system running on SQL server 2k. My question is
> this - In the maintenance plan, database backups,
> transaction backups, etc...under properties it is backing
> up 'master', everything is fine. However, our database
> is 'WFT' shouldn't the database be set to WFT instead
> of 'master'? Or does master contain all databases? I just
> want to be sure we are getting the proper backup. Also
> the job has the No Truncate command which causes the
> event 17055. Can this command be omitted and everything
> still be OK?
> Thanks in advance.
> Darryl|||in addition to the answers you have been given, might I suggest you ask your
company to put a little investment into training for you (I am assuming that
a payroll system is quite important?!)
--
Br,
Mark Broadbent
mcdba , mcse+i
=============
"Darryl" <anonymous@.discussions.microsoft.com> wrote in message
news:824801c431db$326c6560$a001280a@.phx.gbl...
> I have been assigned the task of DBA for our company's
> payroll system running on SQL server 2k. My question is
> this - In the maintenance plan, database backups,
> transaction backups, etc...under properties it is backing
> up 'master', everything is fine. However, our database
> is 'WFT' shouldn't the database be set to WFT instead
> of 'master'? Or does master contain all databases? I just
> want to be sure we are getting the proper backup. Also
> the job has the No Truncate command which causes the
> event 17055. Can this command be omitted and everything
> still be OK?
> Thanks in advance.
> Darryl

Databases

I have been assigned the task of DBA for our company's
payroll system running on SQL server 2k. My question is
this - In the maintenance plan, database backups,
transaction backups, etc...under properties it is backing
up 'master', everything is fine. However, our database
is 'WFT' shouldn't the database be set to WFT instead
of 'master'? Or does master contain all databases? I just
want to be sure we are getting the proper backup. Also
the job has the No Truncate command which causes the
event 17055. Can this command be omitted and everything
still be OK?
Thanks in advance.
Darryl
The link here should help you
http://msdn.microsoft.com/library/de...es_03_378k.asp
I suggest making 2 maintenance plans. I would do one for your System
Databases and select All System Databases in the wizard. Then do another
for All User Databases. For Backups I also have the wizard put all backups
in their own subdirectories. This makes viewing easier and you can easily
see what is going on.
Jeff Duncan
MCDBA, MCSE+I
"Darryl" <anonymous@.discussions.microsoft.com> wrote in message
news:824801c431db$326c6560$a001280a@.phx.gbl...
> I have been assigned the task of DBA for our company's
> payroll system running on SQL server 2k. My question is
> this - In the maintenance plan, database backups,
> transaction backups, etc...under properties it is backing
> up 'master', everything is fine. However, our database
> is 'WFT' shouldn't the database be set to WFT instead
> of 'master'? Or does master contain all databases? I just
> want to be sure we are getting the proper backup. Also
> the job has the No Truncate command which causes the
> event 17055. Can this command be omitted and everything
> still be OK?
> Thanks in advance.
> Darryl
|||in addition to the answers you have been given, might I suggest you ask your
company to put a little investment into training for you (I am assuming that
a payroll system is quite important?!)
--
Br,
Mark Broadbent
mcdba , mcse+i
=============
"Darryl" <anonymous@.discussions.microsoft.com> wrote in message
news:824801c431db$326c6560$a001280a@.phx.gbl...
> I have been assigned the task of DBA for our company's
> payroll system running on SQL server 2k. My question is
> this - In the maintenance plan, database backups,
> transaction backups, etc...under properties it is backing
> up 'master', everything is fine. However, our database
> is 'WFT' shouldn't the database be set to WFT instead
> of 'master'? Or does master contain all databases? I just
> want to be sure we are getting the proper backup. Also
> the job has the No Truncate command which causes the
> event 17055. Can this command be omitted and everything
> still be OK?
> Thanks in advance.
> Darryl

Databases

I have been assigned the task of DBA for our company's
payroll system running on SQL server 2k. My question is
this - In the maintenance plan, database backups,
transaction backups, etc...under properties it is backing
up 'master', everything is fine. However, our database
is 'WFT' shouldn't the database be set to WFT instead
of 'master'? Or does master contain all databases? I just
want to be sure we are getting the proper backup. Also
the job has the No Truncate command which causes the
event 17055. Can this command be omitted and everything
still be OK?
Thanks in advance.
DarrylThe link here should help you
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_03_378k.asp
I suggest making 2 maintenance plans. I would do one for your System
Databases and select All System Databases in the wizard. Then do another
for All User Databases. For Backups I also have the wizard put all backups
in their own subdirectories. This makes viewing easier and you can easily
see what is going on.
--
Jeff Duncan
MCDBA, MCSE+I
"Darryl" <anonymous@.discussions.microsoft.com> wrote in message
news:824801c431db$326c6560$a001280a@.phx.gbl...
> I have been assigned the task of DBA for our company's
> payroll system running on SQL server 2k. My question is
> this - In the maintenance plan, database backups,
> transaction backups, etc...under properties it is backing
> up 'master', everything is fine. However, our database
> is 'WFT' shouldn't the database be set to WFT instead
> of 'master'? Or does master contain all databases? I just
> want to be sure we are getting the proper backup. Also
> the job has the No Truncate command which causes the
> event 17055. Can this command be omitted and everything
> still be OK?
> Thanks in advance.
> Darryl|||Darryl,
this is a simplification, but a typical plan is to do a
full back up of each of your user databases once a day and
much more frequent transaction log backups (eg every 30
mins). The log backups should be truncated, apart from in
the case of the 'live' log for disaster recovery.
The system databases should also be backed up and their
frequency will depend on how often you add logins, jobs
etc, but perhaps you might start with once a day.
All of this could be done using maintenance plans. Some of
the alternative options are not available in maintenance
plans (eg differential backups), but for this strategy it
is OK.
In books on line (BOL) there are plenty of details
explaining the various posibilities and setup techniques
(see "Backing Up and Restoring Databases").
HTH
Paul Ibison|||in addition to the answers you have been given, might I suggest you ask your
company to put a little investment into training for you (I am assuming that
a payroll system is quite important?!)
--
--
Br,
Mark Broadbent
mcdba , mcse+i
============="Darryl" <anonymous@.discussions.microsoft.com> wrote in message
news:824801c431db$326c6560$a001280a@.phx.gbl...
> I have been assigned the task of DBA for our company's
> payroll system running on SQL server 2k. My question is
> this - In the maintenance plan, database backups,
> transaction backups, etc...under properties it is backing
> up 'master', everything is fine. However, our database
> is 'WFT' shouldn't the database be set to WFT instead
> of 'master'? Or does master contain all databases? I just
> want to be sure we are getting the proper backup. Also
> the job has the No Truncate command which causes the
> event 17055. Can this command be omitted and everything
> still be OK?
> Thanks in advance.
> Darryl

Database wont backup or anything...

Hi

I have a database on my SQL Server which since Saturday will not backup. It is part of a maintenance plan which should do backup, log and optimisations. None of these will work on this database. Running a backup manually or using the maintenance plan jobs once started the job just sits there saying 'Executing job step 1'.

We had a problem with the server on Friday to do with tape backups and the server was rebooted. There was no issue with SQL Server its self. All other databases are OK and backup normally even those in the same maintenance plan as this dodgy database.

The system which uses this database works fine with no problems. EDIT: I should add that the first attempt at backing up where I realised there was a problem I stopped the backup from running and it said it had been going for 102 Hours! Even though it went for that amount of time it made no progress. The database only normally takes about 30 secs to a minute to backup.

What can I do to fix this?

Neil.are you able to backup the database through the QA or EM?|||Hi

It does not work in EM but I will give QA a quick try.

Neil.|||Have tried QA and that isn't working either. I set stats to 10 so it should give me some progress but I don't get anything :(|||Don't use a Maint Plan?

Write the backup yourself, or steal one

You should be able to find something here

http://weblogs.sqlteam.com/tarad/category/95.aspx|||how much space is on the destination drive and how big is your database?|||Run sp_who2 in Query Analyzer. Look for a session that is labeled "Backup database". Kill that SPID. It is possible that you have a failed backup that is blocking all others.|||Database is 50Mb and directory has about 25gig spare. Have just tried sp_who2 and there i only one thing in the list relating to my database and its me. There are no Backup Database commands running.|||Something I did get yesterday but forgot to post was when running the backup in QA it responded after several minutes saysing:

Server: Msg 3201, Level 16, State 1, Line 1
Cannot open backup device 'D:\'. Device error or device off-line. See the SQL Server error log for more details.
Server: Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.

Is this trying to tell me my D drive is offline or something? If so it lies because that's where everything else is backing up to OK.

Neil.|||Have u changed the location of ur backups lately....try changing the folder location there might be some permissions issues on that particular drive......|||Mystery almost solved...

Have changed the backup directory to use the L drive instead and I can backup the database sucessfully. If I try a backup on the usual D drive area it fails or never starts.

This is what I think happened:

The server I am using is a cluster between two servers so and at the weekend our techies had a problem with the tape software on one of the servers say ServerX. The cluster was currently running on ServerX and when they had to reboot it the cluster failed over to ServerY. So now the cluster is on ServerY and for some reason I can't backup this database to ServerY D drive.

Does that sound about right? Anyone know why I woul have issues with one database not saving to the D drive?|||Seems ok now we backed up to L drive ok. Now tried D drive again and that works. Weired...